Linux 下安装 MySQL
来源:互联网 发布:淘宝文玩核桃 编辑:程序博客网 时间:2024/06/08 18:09
安装MySQL
安装MySQL:sudo rpm -Uvh mysql57-community-release-el7-11.noarch.rpm安装MySQL社区服务器:sudo yum install mysql-community-server启动MySQL:sudo systemctl start mysqld开机启动或不启动:sudo systemctl enable/disable mysqld临时密码:sudo grep 'temporary password' /var/log/mysqld.log修改密码:ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass4!'授予权限:GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'youpassword' WITH GRANT OPTION更新权限:FLUSH PRIVILEGES临时关闭SELinux:setenforce 0启动MySQL服务:service mysqld start
关闭MySQL服务:service mysqld stop
重启MySQL服务:service mysqld restart查看MySQL的状态:service mysqld status启动一个服务:systemctl start firewalld.service
停止一个服务:systemctl stop firewalld.service
重启一个服务:systemctl restart firewalld.service显示一个服务的状态:systemctl status firewalld.service
查看防火墙:firewall-cmd --state关闭防火墙:systemctl stop firewalld.service关闭防火墙:service iptables stop
重启防火墙:service iptables restart
保存:service iptables save
查看:cat /var/log/mysqld.log启动MySQL服务:systemctl start mysqld.service(如果出现报错很大可能是/var/lib/mysql目录及下面的文件的属主和属组问题)获取临时密码:命令:grep 'temporary password' /var/log/mysqld.log密码:2099-01-1T00:00:00.000000Z 1 [Note] A temporary password is generated for root@localhost: zpyt)qgDA6yq临时密码进入MySQL服务:命令:mysql -uroot -p密码:Enter password: zpyt)qgDA6yq修改密码:set password for 'root'@'localhost'=password('P@ssw0rd');进入MySQL:mysql -u root -p查看表:show databases;
查看字符集:show variables like 'chara%';退出MySQL:exit;开起3306端口:iptables -I INPUT -p tcp --dport 3306 -j ACCEPT保存配置:service iptables save查看MySQL日志:cd /var/lib/mysql查看服务:chkconfig --list修改用户密码:mysqladmin -u root -p password改变文件所有者:chown 用户名 文件名修改字符编码:配置文件位置:/usr/share/mysql/my-small.cnf拷贝文件到指定位置:cp /usr/share/mysql/my-small.cnf /etc/my.cnf修改配置文件:my.cnf在MySQL下面加:character_set_server = utf8重启MySQL服务:service mysql restart(sudo systemctl restart mysqld)Navicat Premium可访问,需要授权:grant all privileges on *.* to root@'%' identified by 'P@ssw0rd' with grant option;flush privileges;错误问题:执行service iptables stop出现错误解决方法:切换到root用户,执行命令:
# yum install iptables-service
# service enable iptables --设置开机启动# service iptables [start|stop|restart|save]RPM安装rpm -i 安装软件名 (install)
rpm -ivh 安装软件名(显示进度)
阅读全文
1 0
- Linux下安装Mysql
- Linux下安装MySQL
- Linux下安装MYSQL
- Linux下安装mysql
- LINUX下安装MySQL
- Linux下安装MySQL
- Linux下安装MySQL
- linux下安装mysql
- Linux下安装Mysql
- Linux下安装MySQL
- Linux 下安装mysql
- linux下安装mysql
- Linux下mysql安装
- Linux下安装MySql
- Linux下mysql安装
- linux下安装mysql
- linux下安装mysql
- linux下安装mysql
- Java中Synchronized的用法
- Ubuntu 16中如何安装TeamViewer 12
- Improving Deep Neural Networks Initialization 参考答案
- 挂载目录到数据库docker容器
- Oracle安装与配置
- Linux 下安装 MySQL
- Linux中jdk的安装
- mysql 数据库整理——数据表数据的增删改查
- github+hexo搭建自己的博客网站(六)进阶配置(搜索引擎收录,优化你的url)
- Android--(5)--详解ImageView属性
- MP4结构分析
- Windows程序设计-定时器
- JVM、Java编译器和Java解释器
- matlab2c使用c++实现matlab函数系列教程-unifstat函数