View Single Post
  #2  
Old 08-17-2006, 10:51 AM
sierra sierra is offline
Senior Member
 
Join Date: Jul 2006
Posts: 220
Thanks: 0
Thanked 1 Time in 1 Post
Rep Power: 18
sierra is on a distinguished road
Default

It looks as if commands entered at the mysql> prompt need to be terminated by a delimiter, which defaults to a semicolon:

mysql> CREATE USER 4h77lgs@localhost IDENTIFIED BY PASSWORD '12345';
mysql> GRANT ALL ON database1.* TO 4h77lgs@localhost IDENTIFIED BY '12345';
mysql> SET PASSWORD FOR 4h77lgs = PASSWORD('12345'); -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --
Reply With Quote
  Webmaster Forums - View Single Post - user account troubles>>>
View Single Post
  #2  
Old 08-17-2006, 10:51 AM
sierra sierra is offline
Senior Member
 
Join Date: Jul 2006
Posts: 220
Thanks: 0
Thanked 1 Time in 1 Post
Rep Power: 18
sierra is on a distinguished road
Default

It looks as if commands entered at the mysql> prompt need to be terminated by a delimiter, which defaults to a semicolon:

mysql> CREATE USER 4h77lgs@localhost IDENTIFIED BY PASSWORD '12345';
mysql> GRANT ALL ON database1.* TO 4h77lgs@localhost IDENTIFIED BY '12345';
mysql> SET PASSWORD FOR 4h77lgs = PASSWORD('12345'); -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --
Reply With Quote