Omega002
asked on
How To Create A MySQL Database Account Using version 4.1.22
What is the syntax to create a new database user for MySQL 4.1.22? I tried the following syntax listed below but it did not work:
1) CREATE USER dba01 IDENTIFIED BY 'password1';
2) CREATE USER 'dba01'@'localhost' IDENTIFIED BY 'password1';
1) CREATE USER dba01 IDENTIFIED BY 'password1';
2) CREATE USER 'dba01'@'localhost' IDENTIFIED BY 'password1';
What about error messages?
ASKER
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'USER 'dba01'@'localhost' IDENTIFIED BY 'p@ssw0rd01'' at line 1
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
NA
ASKER
NA