时间：2021-07-01 10:21:17 帮助过：2人阅读
rpm -ivh mysql-community-release-el7-5.noarch.rpm
ls -1 /etc/yum.repos.d/mysql-community*yum install mysql-serverservice mysqld start或者/etc/init.d/mysqld start---进入mysql (mysql -uroot) 需要先配置密码
方法1： 用SET PASSWORD命令
MySQL -u root
mysql> SET PASSWORD FOR ‘root‘@‘localhost‘ = PASSWORD(‘newpass‘);
方法2：用mysqladmin
mysqladmin -u root password "newpass"
如果root已经设置过密码，采用如下方法
mysqladmin -u root password oldpass "newpass"
方法3： 用UPDATE直接编辑user表
mysql -u root
mysql> use mysql;
mysql> UPDATE user SET Password = PASSWORD(‘newpass‘) WHERE user = ‘root‘;
mysql> FLUSH PRIVILEGES;
在丢失root密码的时候，可以这样
mysqld_safe --skip-grant-tables&
mysql -u root mysql
mysql> UPDATE user SET password=PASSWORD("new password") WHERE user=‘root‘;
mysql> FLUSH PRIVILEGES;
查看最大连接数
show variables like ‘max_connections‘;
show tables;
错误日志文件路径
mysql> show variables like ‘log_error‘;
慢查询日志文件路径
mysql> show variables like ‘slow_query_log_file‘;
日志文件路径
mysql> show variables like ‘general_log_file‘;
centos7下安装mysql
标签：-- etc /etc/ 进程 ase ret number server 查询日志