PDA

View Full Version : Problems with mySQL


dema
August 27th, 2006, 09:21 AM
I'm installing mySQL like this:
http://ubuntuguide.org/wiki/Dapper#How_to_install_MYSQL_Database_Server

But when entering:
mysqladmin -h root@dennis-laptop -u root password my-password

I get this error:

mysqladmin: connect to server at 'root@dennis-laptop' failed
error: 'Unknown MySQL server host 'root@dennis-laptop' (1)'
Check that mysqld is running on root@dennis-laptop and that the port is 3306.
You can check this by doing 'telnet root@dennis-laptop 3306'


Can anybody tell me why?

Klaidas
August 27th, 2006, 09:33 AM
Try using "localhost" instead of "root@dennis-laptop"

Again, this is a wrong subforum :)

dema
August 27th, 2006, 01:26 PM
Now I enter:
mysqladmin -h localhost -u root password myPassword

And get this error:
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'

Why?

Klaidas
August 27th, 2006, 05:06 PM
Hmm.
Try using http://www.linux.org/lessons/interm/x2081.html#MYSQL-INTRO