Permissions in MySQL Monitor help.

Hi,  I am trying to create a simple database for class and do not have permission when entering commands in MySQL monitor.  Sure this is simple but having a difficult time.  Can someone assist?  I am using a WAMP localhost on my Win 7 64 bit machine.
Deanna AndruAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

GaryCommented:
Are you logged into MySQL with the username/password? If this is a default install then it would be root and empty password.
0
AielloJCommented:
Deanna Andru:

After you create the database, you have to grant permissions to the tables, and the user(s).  the GRANT command tells it which tables the user has credentials for.  The 'ALL' after the GRANT says the user all privileges on the tables specified after the ON clause.  The <database name>.* indicates the user has these privileges on all tables in the database.

The SET PASSWORD line assigns the password to the username specified.  The term after the @ says from what hostname or IP address the user would be logging in from.  This enables you to allow a user to log in only from certain hostnames or IP addresses.  The '%' in the example below says to let the user log in from any host.

CREATE DATABASE
<database name>;

GRANT ALL ON <database name>.* TO <username> IDENTIFIED BY '<password>';

SET PASSWORD FOR '<username>'@'%' = OLD_PASSWORD('<password>');

Hope this helps.  Best regards,

AielloJ
0
Deanna AndruAuthor Commented:
I reinstalled WAMP.  When accessing the phpMyAdmin panel I see the following error:
Your configuration file contains settings (root with no password) that correspond to the default MySQL privileged account. Your MySQL server is running with this default, is open to intrusion, and you really should fix this security hole by setting a password for user 'root'.
At this point, I cant create a database. and I don't know where to find the terminal.
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

GaryCommented:
For local development it's fine to just use root.
If you installed WAMP then it will have installed PHPMyAdmin which you will normally access with
http://localhost/phpmyadmin
(easier than using a terminal)
0
Deanna AndruAuthor Commented:
Thank you for the assist, I was able to locate the mysql terminal.  The instructions say to begin by typing at the mysql> prompt: mysql -h host -u user -p.  With this I am able to use it.  I am still unsure of the permissions with the error at phpMyAdmin panel:  

"Your configuration file contains settings (root with no password) that correspond to the default MySQL privileged account. Your MySQL server is running with this default, is open to intrusion, and you really should fix this security hole by setting a password for user 'root'."

Working on the assignment and will update with any issues or errors.
0
GaryCommented:
It's just a warning, to get rid of it set a password on the root account.
0
Deanna AndruAuthor Commented:
uuuuh.  Ok I did and now not able to access PHPMyAdmin - I take it that was not the right root account...
0
GaryCommented:
You can only have one root account, once you set the password then you will need that to login to MySQL
0
Deanna AndruAuthor Commented:
ok, I am reinstalling wamp again, any pointers on how to set the password in the init files or how to access to set when installing wamp?
0
Deanna AndruAuthor Commented:
only one root....  will list when I get back there if more than one.  there were three, one local host, then some others.  I am so glad for the assist :-)
0
GaryCommented:
You don't need to reinstall, just log in using root and the password you set
0
Deanna AndruAuthor Commented:
Hi again,  I installed XAMP with an admin account on my win 7 64 bit machine this time.   The instructions for the initial setup at the beginning of class was for WAMP, the instructor now shows an example for XAMPP  when accessing phpMyAdmin.  I am a total newbe.   How do I log in using root and the password if I never set a password on the local machine exactly?   I now have XAMPP v3.2.1 installed and am able to follow class instructions precisely - hopefully.  Will check back.
0
GaryCommented:
If you never set a password during the installation then there is no password - it's blank
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Deanna AndruAuthor Commented:
I am able to follow the instructions in XAMPP administrator window for mysql with this setup.  I was able to create a database without any permission issues so far.  :-)
0
Deanna AndruAuthor Commented:
I was able to log in successfully and create databases with SQL.  Thank you for the assist.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Web Languages and Standards

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.