Jump to content

Archived

This topic is now archived and is closed to further replies.

davidspeare

CMD Line log in

Recommended Posts

Hello,

I have recently been trying to learn PHP and MySQL with a help guide. I am now at a point in my manual that I need to get back into the default tables that were loaded with MySQL. I am being told that I don't have the permission, but for the life of me, I can't figure out how to acutally log in at the command prompt.

Please help,

Thank you,

Share this post


Link to post
Share on other sites
Not sure what you mean... MySQL only sets up mysql, users and test tables. If you lost mysql, you're in trouble, users you can recover, and test is just a playground.

Share this post


Link to post
Share on other sites
[!--quoteo(post=367881:date=Apr 24 2006, 02:17 AM:name=fenway)--][div class=\'quotetop\']QUOTE(fenway @ Apr 24 2006, 02:17 AM) [snapback]367881[/snapback][/div][div class=\'quotemain\'][!--quotec--]
Not sure what you mean... MySQL only sets up mysql, users and test tables. If you lost mysql, you're in trouble, users you can recover, and test is just a playground.
[/quote]
Thanks for answering this.

What i mean is that I am typing the command to show the tables in the database mysql. However, the command prompt is telling me that I don't have the permission to log in. Let me take one step even further back. I am changing my command prompt to mysql>. From here i am typing the command "Show Databases;" and I am getting Test and MySQL returned. Then when I want to see the tables in mysql i am getting the error that I am not authorized. I think I need to log in, but I don't know how...

is that enough to help?

Thanks?

Share this post


Link to post
Share on other sites
Usually, if you're running it locally, you can always login with "mysql -u root", and then specify your password. If not, perhaps your grant tables are a mess.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.