Linux install MySQL a little bit of finishing

One. Installation steps:

1. Go to the MySQL website under the two RPM installation package. Client (for example: mysql-client-5.5.43-1.linux2.6.i386.rpm) and server-side (e.g. mysql-server-5.5.43-1.linux2.6.i386.rpm)

2. On the Linux system, hit the following command: RPM-QA | grep MySQL detects if the system has the associated software to install MySQL. For the associated software, be sure to delete it. Otherwise, this will happen: 650) this.width=650; "Src=" http://s3.51cto.com/wyfs02/M00/5D/BA/wKioL1Uj573y1r3OAAHf0yfUpfw659.jpg " Title= "does not remove the Lib file as it looks. PNG "alt=" Wkiol1uj573y1r3oaahf0yfupfw659.jpg "/> 3. Verify that MySQL is properly installed: Enter Netstat-nat to see if the port number is 3306

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/5D/BA/wKioL1Uj6MvBh84BAADA-uAVWRo906.jpg "title=" Port 3306 . PNG "alt=" Wkiol1uj6mvbh84baada-uavwro906.jpg "/>

Two. Configuration phase

1.mysql service Open, restart, and Deactivate commands:

There are two kinds of forms: service MySQL Start/restart/stop

or/etc/init.d/mysql Start/stop/restart

2. How to set up automatic MySQL service on boot:

First Verify Boot: command chkconfig--list | grep MySQL

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/5D/BA/wKioL1Uj7DHhC0cWAAB4sRcB2k8038.jpg "title=" boot up. PNG "alt=" Wkiol1uj7dhhc0cwaab4srcb2k8038.jpg "/>

If the status of the red Line callout appears in the graph, the MySQL service is set to boot automatically. Otherwise, you can tap the following command:

Chkconfig MySQL on to set it to boot.

3. To enter and launch the MySQL command line method:

After the first install MySQL default account mysql No password, you can directly hit MySQL to enter the command line. The command to add an account password is: mysqladmin-u root-p ' knock password ' here root is MySQL account

Login mode with password: mysql-u root-p:

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/5D/BF/wKiom1Uj7UGCsBFCAAFvcVN29dg105.jpg "title=" login. PNG "alt=" Wkiom1uj7ugcsbfcaafvcvn29dg105.jpg "/>

Exit command line is: left; such as < should pay special attention to the colon after the Quit >

>650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/5D/BA/wKioL1Uj75ChqOykAABnDww1xvc846.jpg "title=" Launches the command line. PNG "alt=" Wkiol1uj75chqoykaabndww1xvc846.jpg "/>

4. Configuration files

The method of installing MySQL in RPM will be missing the my.cnf file in the/etc directory. The workaround is to simply copy the/usr/share/mysql/my-medium.cnf file to the/etc directory and rename it to MY.CNF.

Command: CP/USR/SHARE/MYSQL/MY-MEDIUM.CNF/ETC/MY.CNF

< write at the end, MySQL configuration operation is not yet complete, this is just a start >

This article is from the "scraps of Knowledge" blog, be sure to keep this source http://10099932.blog.51cto.com/10089932/1629853

Linux install MySQL a little bit of finishing