Bruce,
I had the same problem as indicated in my earlier posting.
This is the way I fixed it. I am not saying that all the steps are required.
1) I did a password reset as desribed in the document below.
http://www.familybrown.org/howtos/mysql-password-howto.html2) started mysql
[root@kobifix root]# mysql -u root mysql -p
Enter password:(here I entered the SME root 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 23411 to server version: 3.23.49
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql>
3)grant the required privileges
mysql> grant all privileges on *.* to root@localhost identified by 'mysmerootpassword';
Query OK, 0 rows affected (0.00 sec)
(I am not sure if the admin is needed, most probably not)
mysql> grant all privileges on *.* to admin@localhost identified by 'mysmerootpassword';
Query OK, 0 rows affected (0.00 sec)
mysql> \q
Bye
[root@kobifix root]#
Remark: I am not a expert in mysql, may be there is a possibility that I broke a security role with the steps above. It would be nice to hear back form the experts.
Hope it works for you as well.
Best regards
jakob
22 Replies
1586 Views