<div>
use the commandline<br />
mysql -u user -p (enter)<br />
<br />
Now you can type the password of the user called &quot;user&quot;.
</div>


use the commandline
mysql -u user -p (enter)

Now you can type the password of the user called "user".

<div>
To use the command line on the same machine as the MySQL server, a user must be created with a 'localhost' connection.
</div>


To use the command line on the same machine as the MySQL server, a user must be created with a 'localhost' connection.

<div>
<div class="content wysiwyg-content">
After installing WAMP server and start the MySQL, it always ask for root password.<br />
<br />
How to configure the MySQL console such that always user name and password is asked ?<br />
<br />
How to test whether a new created user can access a particular database through the console ?<br />
<br />
Tks
</div>
</div>


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

Login mysql with other user

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.