Could not create an user sysaid on RHEL 6.2, tomcat 7, JRE1.7, MYSQL 5.1

Linux Beginners / Newbie
1

Transfered from Linux Config Disqus comments:

Question:
i could not create an user sysaid on RHEL 6.2, tomcat 7, JRE1.7, MYSQL 5.1.

mysql> CREATE USER sysaid@localhost IDENTIFIED BY ‘sysaidpass’;
ERROR 1396 (HY000): Operation CREATE USER failed for ‘sysaid’@‘localhost’
mysql>

2

Hi,

Here are few things your want to try:

mysql> FLUSH PRIVILEGES;
mysql> drop user sysaid@localhost; FLUSH PRIVILEGES; CREATE USER sysaid@localhost IDENTIFIED BY 'sysaidpass';

Let me know if this does not help !

3

I’ve noticed sometimes that MySQL can be stubborn without the ‘’ around the username…

CREATE USER ‘sysaid’@‘localhost’ IDENTIFIED BY ‘sysaidpass’