Installation and configuration of Linux--mysql

Linux CentOS, MySQL installation three ways: Binary tar package installation, RPM installation, yum installation (simplest)

See if you have installed:
Yum List installed mysql*
Rpm-qa | grep mysql*
To see if there are any installation packages:
Yum List mysql*
To install the MySQL client:
Yum install MySQL
To install the MySQL server side:
Yum Install Mysql-server
Yum Install Mysql-devel

MySQL can be added to the environment variable, in/etc/profile

2. Start && Stop

Database Character Set settings
MySQL config file/etc/my.cnf add Default-character-set=utf8
To start the MySQL service:
Service mysqld start or/etc/init.d/mysqld start
Boot start:
Chkconfig-add mysqld, check if boot boot settings are successful chkconfig--list | grep mysql*
Mysqld 0: Off 1: Off 2: Enable 3: Enable 4: Enable 5: Enable 6: Off
Stop it:
Service Mysqld Stop

3. Login
To create a root administrator:
Mysqladmin-u Root Password 123456
Login:
Mysql-u Root-p Enter the password.
Forgot Password:
Service Mysqld Stop
Mysqld_safe--user=root--skip-grant-tables
Mysql-u Root
Use MySQL
Update user set Password=password ("New_pass") where user= "root";
Flush privileges;

4. Remote Access
Port number for open firewall
MySQL Add permission: The user table in the MySQL library has a new record of "%" and the user is "root".
5. Several important directories of Linux MySQL
Database directory
/var/lib/mysql/
Configuration file
/etc/my.cnf
Related commands
/usr/bin (Mysqladmin mysqldump and other commands)
Startup scripts
/etc/rc.d/init.d/(startup script file for MySQL directory)

This information is available through Ps-ef | grep MySQL to view
[Mysqld]
Datadir=/var/lib/mysql
Socket=/var/lib/mysql/mysql.sock
User=mysql
# Disabling Symbolic-links is recommended to prevent assorted security risks
Symbolic-links=0
Skip-grant-tables
[Mysqld_safe]
Log-error=/var/log/mysqld.log
Pid-file=/var/run/mysqld/mysqld.pid

Installation and configuration of Linux--mysql