How to Login to MySQL Server

MySQL server can be run on both Windows operating system and UNIX family. The query syntax on Win 9x and UNIX family is the same. Syntax query in MySQL is not case sensitive.




As for how to login to Mysql server is as follows:


1. in Win 9x


Open command prompt mode (run -> command), assume MySQL is installed in MySQL directory, then user must move to MySQL directory then go to bin directory.


Assuming, the initial location in the command prompt window is drive C, the user name is mature and the password is ok


Syntax: (note: number to indicate step sequence)


 C:\cd mysql
 C:\mysql> cd bin
 C:\mysql\bin>inmysqladmin
 C:\mysql\bin>mysql -u budi -p
     Password: ***


If successful there will be a prompt


 Welcome to the MySQL monitor. Command end with; tr \ g.


 Your MySQL connection id is 14 to server version: 3.23.49


 Type 'help:' or '\ h' for help. Type '\ c' to clear the buffer.


2. In the UNIX Family


In the shell type


#Mysql -u budi -p

   Password: ***


If successful there will be a prompt


 Welcome to the MySQL monitor. Command end with; Tr \ g.


 Your MySQL connection id is 14 to server version: 3.23.49


 Type 'help:' or '\ h' for help. Type '\ c' to clear the buffer.



So how to get into the MySQL server that can be delivered hopefully useful.