Install MySQL with Yum under Linux

Install mysql 1 with Yum under Linux, install to see if you have installed:          Yum list installed mysql*      &NB Sp   RPM-QA | grep mysql*  See if there are no installation packages:          Yum list mysql*  install MySQL client:        & nbsp Yum install mysql  installation MySQL server-side:          Yum install mysql-server           Yum Install mysql-devel  www.2cto.com  2, start && stop   database character set settings           mysql config file/etc/my.cnf add default-character-set=utf8  start MySQL service:          Service mysqld start or/etc/init.d/mysqld start boot:          Chkconfig-add mysqld, view boot start Set whether successful chkconfig--list | grep mysql*           mysqld             0: Close    1: Off Closed    2: Enable    3: Enable    4: Enable    5: Enable    6: Off stop:          Service mysqld STOP2, login   Create root admin:          mysqladmin-u root password 12345 6  www.2cto.com   Login:          mysql-u root-p Enter your password. Forgot password:          service mysqld stop           Mysqld_safe--user=roo T--skip-grant-tables           mysql-u root           use my sql           Update user set Password=password ("New_pass") where user= "root";           flush privileges;   3, remote access   Open firewall port number MySQL Add permission: The user table in the MySQL library adds a record of host "%" and user as "root".(Reference: error: 1130-host ... is not allowed to connect to this MySQL server open MySQL remote connection does not use localhost blog) 4, Linux MySQL several important directory www.2cto.com database directory/var/lib/mysql/configuration file/usr/share/mysql (mysql.server command and configuration file) related commands /usr/bin (Mysqladmin mysqldump and other commands) startup script/etc/rc.d/init.d/(startup script file mysql directory)

Install MySQL with Yum under Linux