George Posted November 9, 2013 Share Posted November 9, 2013 Re: Forums In chapter 5 I created the database sitename at MySQL command prompt. After exiting the database I would like to open it another time. When entering my password at MySQL server. I am not certain what command to type in at MySQL server command prompt to open it. . Understanding this question may be not be at the newbie. Nor beyond. If anyone could please help? Thank you very kindly. George. Link to comment Share on other sites More sharing options...
StephenM Posted November 10, 2013 Share Posted November 10, 2013 Hi. Check the tip on page 124. mysql -u yourusername -p sitename If successful login, it will directly open the sitename database. Link to comment Share on other sites More sharing options...
George Posted November 11, 2013 Author Share Posted November 11, 2013 Hi Thank you for your response. Brief words. Hoping this makes sense. When I installed MySQL I didn't get an option to create a user name. Just a password. When I enter the coding as you suggested and also trying to implement the example coding that appears on pages 123 and 124. I get an error indicating that I have not entered the proper command at command line. When just opening command prompt I only have an option to enter my password. May there be another way to get around this. Thank you. Link to comment Share on other sites More sharing options...
Larry Posted November 14, 2013 Share Posted November 14, 2013 You aren't prompted to create a username when you install MySQL. By default, MySQL comes with one user named "root" and the password you created would be for that user. Other users are added manually. Link to comment Share on other sites More sharing options...
Recommended Posts