Hi,
I am trying to set up a passsword a system root for the root MySQL
server
for the 1st time (rpm download) & I get the following error message:
[root@localhost MySQL]# /usr/bin/mysqladmin -u mysql -p password
'x1234!'
Enter password:
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'mysql@localhost' (Using password: YES)'
if I run the same command as MySQL root (ie: user mysql):
bash$ /usr/bin/mysqladmin -u mysql -p password 'x1234!'
Enter password:
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (111)'
Check that mysqld is running and that the socket:
'/var/lib/mysql/mysql.sock' exists!
The socket is on /tmp but not on /var/lib/mysql/
Also, should the user specified with -u be 'mysql' (a valid id on my
system)
or should the argument remain 'root' ?
Thanks for your input,
Charles
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
