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 // 强力删除模式,如果使用上面命令删除时,提示有依赖的其它文件,则用该命令可以对其进行强力删除
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.cnfmysqladmin -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.logThe 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)!