MySQL Forums
Forum List  »  Newbie

Using Local Windows Machines, this worked for me
Posted by: Jess Hines
Date: October 16, 2008 11:03AM

THIS IS ALL FOR MYSQL RUNNING ON A LOCAL WINDOWS MACHINE:

I found that having root didn't work as the only account, so I created my own account with priveleges.

So, in the MySQL console, type:

GRANT ALL PRIVILEGES IN *.* TO <username>@localhost IDENTIFIED BY <password>;
This will give <username> all access to all databases and tables, you can restrict access if you want.

Then, after quitting the console screen, go to your the MySQL Administrator and put in 'localhost' as the host, the port should be fine as default, (it will be whatever you set it at when you ran the configuration), and then the username and password you just created.
Hope That Helps



Edited 1 time(s). Last edit at 10/16/2008 11:04AM by Jess Hines.

Options: ReplyQuote


Subject
Written By
Posted
March 06, 2007 11:22PM
February 20, 2008 06:17AM
August 04, 2009 09:05PM
December 15, 2005 12:56AM
Using Local Windows Machines, this worked for me
October 16, 2008 11:03AM
March 03, 2009 11:07PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.