Solved

Login mysql with other user

Posted on 2014-11-17
5
187 Views
Last Modified: 2014-11-18
After installing WAMP server and start the MySQL, it always ask for root password.

How to configure the MySQL console such that always user name and password is asked ?

How to test whether a new created user can access a particular database through the console ?

Tks
0
Comment
Question by:AXISHK
  • 3
5 Comments
 
LVL 35

Expert Comment

by:Kimputer
ID: 40449296
use the commandline
mysql -u user -p (enter)

Now you can type the password of the user called "user".
0
 
LVL 82

Expert Comment

by:Dave Baldwin
ID: 40449313
To use the command line on the same machine as the MySQL server, a user must be created with a 'localhost' connection.
0
 
LVL 82

Accepted Solution

by:
Dave Baldwin earned 500 total points
ID: 40449315
0
 

Author Closing Comment

by:AXISHK
ID: 40449571
Tks
0
 
LVL 82

Expert Comment

by:Dave Baldwin
ID: 40450628
You're welcome.
0

Featured Post

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

Loading csv or delimited data files to MySQL database is a very common task frequently questioned about and almost every time LOAD DATA INFILE comes to the rescue. Here we will try to understand some of the very common scenarios for loading data …
I have been using r1soft Continuous Data Protection (http://www.r1soft.com/linux-cdp/) for many years now with the mySQL Addon and wanted to share a trick I have used several times. For those of us that don't have the luxury of using all transact…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

746 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now