MySQL database creation error

[Compunuts]

I installed MySQL server 4.0.13 on my Debian "testing" box ( stable seems too old for me ).

When I tried to create the database, it spits out this error message.

DebServer:/home/compunuts# mysqladmin create pndb -p
Enter password:
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: YES)'
DebServer:/home/compunuts# exit
exit
compunuts@DebServer:~$ mysqladmin create pndb -p
Enter password:
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'compunuts@localhost' (Using password: YES)'

So what seems to be the problem and how do I fix it? Or point me to something to read?

TIA

[Kernel_Killer]

Did you already set some users? You might give the '-u root' a shot in your command.

Here's a simple way to set users:

mysqladmin -u username password 'password'
mysqladmin -u username -h hostname password 'password'

Now set the perms for that user:

mysql -u username -p -e "GRANT INSERT,SELECT on databasedbfile.* to username@hostname"
mysql -u username -p -e "GRANT INSERT,SELECT on databasedbfile.* to username@localhost"

You can log into mysql as 'root' and use the command SELECT * FROM user; to view user on the database. (Make sure you change DBs first with \u database )

Hope that helps some.

[Compunuts]

Ah, solved the problem but I will leave this post for those who had problems later on.

Logged into the mysql database with

mysql -u root -p

and then enter "password" as your password.

Then change the password using,

mysql> use mysql; 
mysql> UPDATE user SET Password=PASSWORD('mynewpassword') WHERE User='root'; 
mysql> FLUSH PRIVILEGES;

in 'mynewpassword', substitute whatever you like ( but keep the single quote as it's.

HTH for those folks who might encounter the problem later on.

[Compunuts]

How do we add uses to existing database?

For example, if I want user "compunuts" to use the database "pnvs" instead of user "root", how?

TIA

[mcdougrs]

The GRANT command is what you are looking for. Click here for all of the options with the GRANT command

[Kernel_Killer]

Switch databases with the /u command, and then use:

GRANT INSERT, SELECT on database.* to user@hostname;

[Compunuts]

Got it, thanks guys ....