Home  >  Article  >  Database  >  Detailed introduction to linux mysql installation and maintenance

Detailed introduction to linux mysql installation and maintenance

黄舟
黄舟Original
2017-02-28 13:26:111212browse

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)!


Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn