Setting Up MySQL Privileges

[ukgimp]

I finally got a users,db and host tables on a server. I have a root password.

Problems are arrising when trying to add a new user and db. When doing a connection is works if I leave the use rand password "" but if I actually put the password in it cant connect.

This is the most critical part of the operation for me and I feel a little lost. I have been readin about but I cannot seem to nail this.

phpmyadmin has full access to do everything.

Any pointers. mysql admin is complex :)

[jamie]

ukgimp,

i don't know whether this might help, but i had a lot of problems when setting up mysql due to differentiating between localhost and servername connections. eg from the command line:

mysql -u root -h localhost -p

vs.

mysql -u root -h myserver.name.com -p

i had set two different passwords for each one and got myself in a right pickle.

if phpmyadmin works perfectly, have a look at the config.inc.php file online which will contain the root password in the line:

$cfg['Servers'][$i]['password'] = 'mypassword';

that's not a very technical reply but it might help :)

good luck

[ukgimp]

Cheers Jamie

Got the passwd sorted from where you mentioned. Did you sort your problems out?

[jamie]

yeah i did the same

i found the localhost password for phpmyadmin and reset all passwords. was scratching my head for ages ;-)