10-31-2004, 08:54 AM
|
|
|
Quote:
2) In C:\mysql\bin, run mysql.exe
Type into the window:
Code:
GRANT ALL PRIVILEGES ON *.* TO Username@localhost IDENTIFIED BY 'Password' WITH GRANT OPTION;
Replace Username with the username you selected above, and Password with the password you selected above.
It should say something like:
Code:
Query OK, 1 Rows Affected, 0.0sec
Note: If you get an error when typing the grant all privileges line:
1) Make SURE you copied the line of code EXACTLY as written and changed username/password. (you need the ''s(apostrophes) around the password. 'example' not "example" or example.)
2) Try opening a command prompt. Type:
Code:
CD C:\mysql\bin
then type
Code:
mysql -u root mysql
And proceed to type the grant all privileges command again.
|
|