Detailed introduction to linux mysql installation and maintenance-Mysql Tutorial-php.cn

Home

Database

Detailed introduction to linux mysql installation and maintenance

Feb 28, 2017 pm 01:26 PM

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

Copy after login

2. Uninstall the original database

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

Copy after login

## 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

Copy after login

2. Install the database

                    yum install  -y  mysql-server  mysql  mysql-deve

Copy after login

3. Check the installed database version

                     rpm -qi mysql-server

Copy after login

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

Copy after login

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

chkconfig --list | grep mysqld

Copy after login

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

chkconfig mysqld on

Copy after login

  /usr/bin/mysqladmin -u root password &#39;new-password&#39;

Copy after login

8 . Enter mysql: #mysql -u root

3. View the database configuration file location

1. cat /etc/my.cnf

mysqladmin -u root password &#39;root&#39;

Copy after login

##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

Copy after login

##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

Copy after login

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 of this Website

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