本文共 4142 字,大约阅读时间需要 13 分钟。
= MySQL安装包:
- MySQL-5.6.43-1.el7.x86_64.rpm-bundle.tar
= 依赖包:
- libaio-0.3.109-13.el7.x86_64.rpm
- net-tools-2.0-0.24.20131004git.el7.x86_64.rpm
- numactl-2.0.9-7.el7.x86_64.rpm
- numactl-devel-2.0.9-7.el7.x86_64.rpm
- numactl-libs-2.0.9-7.el7.x86_64.rpm
- perl-Data-Dumper-2.145-3.el7.x86_64.rpm
Linux发行版:CentOS-7-x86_64-DVD-1804.iso
FTP工具:FileZilla_3.32.0-rc1_win64-setup.exe
MySQL安装包下载:https://dev.mysql.com/downloads/mysql/
依赖包下载:https://pkgs.org/
#--查询# rpm -qa | grep mysql# rpm -qa | grep mariadb#--卸载# rpm -e --nodeps mariadb-libs-5.5.56-2.el7.x86_64
# rpm -ivh net-tools-2.0-0.24.20131004git.el7.x86_64.rpm# rpm -ivh libaio-0.3.109-13.el7.x86_64.rpm# rpm -ivh perl-Data-Dumper-2.145-3.el7.x86_64.rpm# rpm -ivh numactl*
#--解压# tar -xvf MySQL-5.6.43-1.el7.x86_64.rpm-bundle.tar#--mysql安装# rpm -ivh MySQL-devel-5.6.43-1.el7.x86_64.rpm# rpm -ivh MySQL-client-5.6.43-1.el7.x86_64.rpm# rpm -ivh MySQL-embedded-5.6.43-1.el7.x86_64.rpm# rpm -ivh MySQL-test-5.6.43-1.el7.x86_64.rpm# rpm -ivh MySQL-shared-5.6.43-1.el7.x86_64.rpm# rpm -ivh MySQL-shared-compat-5.6.43-1.el7.x86_64.rpm# rpm -ivh MySQL-server-5.6.43-1.el7.x86_64.rpm
# service mysql start# service mysql status
A random root password has been set. You will find it in ‘/root/.mysql_secret’.
#--输出随机密码cat /root/.mysql_secret | grep password
- 数据库目录:/var/lib/mysql/
- 配置文件目录:/usr/share/mysql
- 相关命令目录:/usr/bin
- 启动脚本:/etc/init.d/mysql
# mysql -uroot -p# 输入密码(上面的随机密码,密码区分大小写)
mysql> show databases;ERROR 1820 (HY000): You must SET PASSWORD before executing this statement
#--修改密码mysql> set password=password('root1234');
mysql> use mysql;
mysql> select host,user,password,password_expired from user;
mysql> update user set password=password('root1234') where user='root';mysql> flush privileges;
mysql> select host,user,password_expired from user;+-----------------------+------+------------------+| host | user | password_expired |+-----------------------+------+------------------+| localhost | root | N || localhost.localdomain | root | Y || 127.0.0.1 | root | Y || ::1 | root | Y |+-----------------------+------+------------------+4 rows in set (0.00 sec)
mysql> use mysql;mysql> update user set password_expired='N' where user='root';mysql> flush privileges;
host = localhost
改为 host = %
mysql> select host,user,password_expired from user;+-----------------------+------+------------------+| host | user | password_expired |+-----------------------+------+------------------+| localhost | root | N || localhost.localdomain | root | N || 127.0.0.1 | root | N || ::1 | root | N |+-----------------------+------+------------------+4 rows in set (0.00 sec)
mysql> update user set host='%' where user='root' and host='localhost';mysql> flush privileges;
备注:如果不能远程,请检查一下端口状态。
# cp /usr/share/mysql/my-default.cnf /etc/my.cnf
[root@localhost etc]# service mysql restart
Linux:
- 数据库和表名严格区分大小写;
- 表的别名严格区分大小写;
- 列名和列的别名忽略大小写;
- 变量名严格区分大小写
Windows:
- 不区分大小写
Mac OS:
- 不区分大小写
mysql> show variables like 'lower%';+------------------------+-------+| Variable_name | Value |+------------------------+-------+| lower_case_file_system | OFF || lower_case_table_names | 0 |+------------------------+-------+2 rows in set (0.01 sec)
[mysqld]lower_case_table_names=1
mysql> select version() from dual;+-----------+| version() |+-----------+| 5.6.43 |+-----------+1 row in set (0.00 sec)
#--启动# service mysql start#--查看状态# service mysql status#--停止# service mysql stop#--重启# service mysql restart#--重新加载配置文件# service mysql reload
转载地址:http://yknws.baihongyu.com/