LOGIN
In CMD:
>>mysql.exe –uroot –p
>>Enter Password: ********
>>mysql>
It’s like this:
mysql -uusername -ppassword –hhost
Attention: There is no blank after the parameters: -u, -p, –h
The MySQL client program, also known as the MySQL monitor, is an interface that allows the user to connect to the MySQL server, create and modify databases, and execute queries and view their results. This program is started by executing the command mysql at the shell prompt. In general, the syntax for this command is:
%>mysql [options] [database]
HELP
HELP
%>mysql –help
SET PASSWORD
Set Password
mysql>SET PASSWORD FOR 'root'@'localhost' = PASSWORD('secret_password');
SELECT DATABASE
Select Database
%>mysql -u root -p mysql
-
mysql>use mydatabase