MySQL: Specifying connection parameters

This entry is part 5 of 26 in the series Learn MySQL

If you would like to fix the connection to only one user, you can update a plain text file my.ini.

If you use WAMP, the file my.ini is located in C:\wamp\bin\mysql\mysql5.6.12.

I have edited mine to:


host = localhost

user = dbuser

password = dbuser

Now if you type mysql in the command line, you will be login as dbuser.

Series Navigation<< MySQL: Check status and user
MySQL: Reading SQL statements from file >>