Detailed introduction to linux mysql installation and maintenance

Recently I have been researching and using mysql. As I know nothing about server knowledge, I still need to start from the basics. First, start with the installation of mysql. The installation steps are as follows:

1 , Uninstall the original database

1. Check whether the system has installed the database
##

rpm -qa | grep mysql

2. Uninstall the original database          

   rpm -e mysql　　// 普通删除模式
 rpm -e --nodeps mysql　　// 强力删除模式，如果使用上面命令删除时，提示有依赖的其它文件，则用该命令可以对其进行强力删除

## If the above command still cannot be deleted, You can refer to: "How to completely uninstall the mysql database in Linux"

2. Use yum to install the database

1. Query the database version provided by yum

                     yum list | grep mysql

2. Install the database

                    yum install  -y  mysql-server  mysql  mysql-deve

3. Check the installed database version

                     rpm -qi mysql-server

4. Start the database
##

 service mysqld start            
 如果命令启动不了：mysql: unrecognized service            
 使用：    /etc/rc.d/init.d/mysqld start            
 修改启动文件权限   chmod 755 /etc/rc.d/init.d/mysqld
 再次启动：service mysqld start

5. Query whether the database is started at startup                                                                                                                                                                ##

chkconfig --list | grep mysqld

7. Set the initial password of the mysql database root user

chkconfig mysqld on

or

  /usr/bin/mysqladmin -u root password 'new-password'

8 . Enter mysql: #mysql -u root

3. View the database configuration file location

1. cat /etc/my.cnf

mysqladmin -u root password 'root'

##2. View mysql data location and logs

 
 
[root@bogon Desktop]# cat /etc/my.cnf
                [mysqld]
                datadir=/var/lib/mysql
                socket=/var/lib/mysql/mysql.sock
                user=mysql
                # Disabling symbolic-links is recommendedto prevent assorted security risks
                symbolic-links=0

##4. Error report modification

The following error occurred when logging in using the root user:

mysqlaccess denied for user 'root'@## Make the following changes:

/var/lib/mysql
             /var/log/mysqld.log

The above is the detailed introduction to the installation and maintenance of linux mysql. For more related content, please pay attention to the PHP Chinese website (www.php.cn)!