Wednesday, July 18, 2012
Set MySQL user password (Suse Linux Enterprise Server 11 terminal cannot type '(' & ')'. )
I had experience an irritating problem where Suse Linux Enterprise Server 11 terminal cant type '(' and ')' parenthesis.
If someone who know what is the cause of this problem, please comment and share with me. Thank you in advance!
So, I find another solution to solve the above problem.
Using MySQL Workbench, connecting to the server which installed mysql.
Tips (If your workbench cant connect to the server):
It is probably cause by the default privileges set in mysql.
you need to edit /etc/my.cnf
add bind-address=0.0.0.0
to allow all remote client to gain access to mysql.
Then, you can now connect to MySQL Workbench with the IP address of the MySQL server.
After connected,
Go to, edit->preferences->SQL editor (tab)->untick 'safe updates'
and reconnect using Workbench.
Finally, execute following query to change password of new installed MySQL (where parenthesis is needed!):
UPDATE mysql.user SET Password=PASSWORD('your-password') WHERE User='root';
FLUSH PRIVILEGES;
Problem Solved.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment