bash-2.05b# mysqladmin -u root -p password 'new-password'
Enter password:
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: YES)'


Run as root... System is running Slackware 9.0, default install pretty much all the way with a few slight mods to things not pertaining to MySQL or PHP or Apache.

mysqld is indeed up and running, the process is up (when I run safe_mysqld I get "error, process already exists").

Any suggestions, anyone?

You can check the MySQL manual for additional info, but at first install, root doesn't have a password. You might try mysqladmin -u root and see where that gets you

mysqladmin -u root

That prints out the syntax help for mysqladmin.

I can connect to the local server just fie with "mysql" but I don't know how to add a user to use with my php files.

[QUOTE}I don't know how to add a user to use with my php files.[/QUOTE]

In which case, check out the MySQL manual for how to add users from within MySQL.

its mysql -u root -p actually !!!!

But to get up and running try this :

Further notes on mysql:
From an initial Slack install the databases have to be created for the users, typing:
mysql_install_db

should create the tables but then the owner for these files needs to be changed to 'mysql' instead of root.
The files in question are in /var/lib/mysql and the owner and group both need to be set to mysql ie:

cd var/lib/mysql
chown -R mysql:mysql mysql

Mysql can then be started:
safe_mysqld &

Lemme know if this is ok


Oops missed a bit :

and mysqladmin used to change the root password:

mysqladmin -u root password 'new-password'

Other users can then be setup on mysql by logging in and then using:

grant all on * to fred identified by 'pass' with grant option;
This would grant all privileges on all db's to fred, see page 192 of PHP and MySQL.

mysqladmin should me mysql i think, but should work both ways , i swear i used mysql not mysqladmin. !!

Yeah, I blew that one. That said, the correct syntax fo myqladmin would be mysqladmin -u=root -p command.

And looking through what mysqladmin commands are available, adding a user isn't one of them so the only way to do it is through mysql.


EDIT

I should add that the MySQL control center has a nice graphical way to add users

Figured it out... bleh long story.

Thanks for you help.