Well i seem to have gotten MySql working but i can't seem to use mysqladmin:
to do anything. When i start MySql with the following:
[root@RR davidwri]# safe_mysqld -u root
Starting mysqld daemon with databases from /var/lib/mysql
it will sit indefinitely as above, is this correct?
If i try to add:
mysql -u root -p mysql
It still just sits,...
[root@RR davidwri]# mysqladmin version
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: NO)'
I did Set the password, based on the following syntax example (with my value,
obviously):
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('secret_password');
So if i cntrl-z:
[1]+ Stopped safe_mysqld -u root
then try:
[root@RR davidwri]# mysql -u root
ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)
[root@RR davidwri]# mysql -u root -p mysql
Enter password:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2 to server version: 3.23.32
Type 'help;' or '\h' for help. Type '\c' to clear the buffer
mysql>
I have never set up and administered MySql myself, so i don't know exactly
what to expect but this is definitely not right. thanks for all your help
---------------------------------------------------------------------
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
