View unanswered posts | View active topics It is currently Sat Jun 25, 2022 10:11 am



Reply to topic  [ 2 posts ] 
 Complete Newbie 
Author Message
Junior Member

Joined: Sun Dec 09, 2007 9:47 pm
Posts: 2
Post Complete Newbie
1. Type CREATE DATABASE databasename CHARACTER SET latin1;
(replace databasename with the name of the database you wish to
create)
2. Press Enter/Return.
3. CREATE USER username@localhost; (Change username to the
username you want, keep @localhost)
4. Press Enter/Return.
5. SET PASSWORD FOR username@localhost =
PASSWORD('newpassword'); (Change username and newpassword to your
selected username and password, again keep @localhost)
6. Press Enter/Return.
7. Type GRANT ALL on databasename.* TO username@localhost;
(Again, change username, keep @localhost)
8. Press Enter/Return.
9. Type quit then Enter/Return to exit the MySQL Monitor.
For some reason unknown I get stuck on step 5. when I type in it looks like this
SET PASSWORD FOR [email="blahblah@localhost"]blahblah@localhost[/email] =
PASSWORD('mypassword');
When I hit the enter button I get 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 'SET PASSWORD FOR [email="blahblah@localhost=PASSWORD('mypassword')'"]blahblah@localhost=PASSWORD('mypassword')'[/email] at line 2 How do I fix this error? any help is greatly appreciated


Sun Dec 09, 2007 9:55 pm
Report this post
Profile
Junior Member

Joined: Sun Dec 09, 2007 9:47 pm
Posts: 2
Post 
Now I have it down to step 7 but it is still giving me errors..:mad:

GRANT ALL on mydatabase.* TO [email="myusername@localhost"]myusername@localhost[/email];

it gives me error 1046 (3d000): No database selected...
What am I doing wrong?


Sun Dec 09, 2007 11:26 pm
Report this post
Profile
Display posts from previous:  Sort by  
Reply to topic   [ 2 posts ] 

Who is online

Users browsing this forum: No registered users and 0 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
© Copyright 2003-2008 www.php-editors.com. The ultimate PHP Editor and PHP IDE site.