davidspeare Posted April 24, 2006 Share Posted April 24, 2006 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, Quote Link to comment https://forums.phpfreaks.com/topic/8220-cmd-line-log-in/ Share on other sites More sharing options...
fenway Posted April 24, 2006 Share Posted April 24, 2006 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 Link to comment https://forums.phpfreaks.com/topic/8220-cmd-line-log-in/#findComment-30008 Share on other sites More sharing options...
davidspeare Posted April 24, 2006 Author Share Posted April 24, 2006 [!--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? Quote Link to comment https://forums.phpfreaks.com/topic/8220-cmd-line-log-in/#findComment-30269 Share on other sites More sharing options...
fenway Posted April 25, 2006 Share Posted April 25, 2006 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. Quote Link to comment https://forums.phpfreaks.com/topic/8220-cmd-line-log-in/#findComment-30653 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.