• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 201
  • Last Modified:

Login mysql with other user

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
AXISHK
Asked:
AXISHK
  • 3
1 Solution
 
KimputerCommented:
use the commandline
mysql -u user -p (enter)

Now you can type the password of the user called "user".
0
 
Dave BaldwinFixer of ProblemsCommented:
To use the command line on the same machine as the MySQL server, a user must be created with a 'localhost' connection.
0
 
Dave BaldwinFixer of ProblemsCommented:
0
 
AXISHKAuthor Commented:
Tks
0
 
Dave BaldwinFixer of ProblemsCommented:
You're welcome.
0

Featured Post

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.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now