1.下載Linux對應的RPM包
http://dev.mysql.com/downloads/mysql/5.6.html
wget http://cdn.mysql.com//Downloads/MySQL-5.6/MySQL-5.6.33-1.el6.x86_64.rpm-bundle.tar
2.解壓tar包
| tar -xvf MySQL-5.6.33-1.el6.x86_64.rpm-bundle.tar |
3.安裝MySQL
| rpm -ivh MySQL-server-5.6.33-1.el6.x86_64.rpm rpm -ivh MySQL-client-5.6.33-1.el6.x86_64.rpm rpm -ivh MySQL-devel-5.6.33-1.el6.x86_64.rpm |
如果出現:
| error: Failed dependencies: libaio.so.1()(64bit) is needed by MySQL-server-5.6.33-1.el6.x86_64 libaio.so.1(LIBAIO_0.1)(64bit) is needed by MySQL-server-5.6.33-1.el6.x86_64 libaio.so.1(LIBAIO_0.4)(64bit) is needed by MySQL-server-5.6.33-1.el6.x86_64 |
下載libaio
| yum install libaio |
如果出現:
| error: Failed dependencies: libnuma.so.1()(64bit) is needed by MySQL-server-5.6.33-1.el6.x86_64 libnuma.so.1(libnuma_1.1)(64bit) is needed by MySQL-server-5.6.33-1.el6.x86_64 libnuma.so.1(libnuma_1.2)(64bit) is needed by MySQL-server-5.6.33-1.el6.x86_64 |
下載numactl
| yum install numactl |
4.初始化MySQL及設置密碼
| /usr/bin/mysql_install_dbservice mysql start |
如果啟動失敗可能是數據塊所在目錄沒有權限
| cat /root/.mysql_secret #查看root賬號密碼mysql> SET PASSWORD = PASSWORD('123456');mysql> exit |
如果.mysql_secret文件不存在,先停止MySQL進入安全模式設置密碼
| service mysql stopmysqld_safe --skip-grant-tables&mysql -u root mysqlmysql> UPDATE user SET password=PASSWORD("new password") WHERE user='root';mysql> FLUSH PRIVILEGES; |
5.允許遠程登陸
| mysql> use mysql;mysql> select host,user,password from user;mysql> update user set host='%' where user='root' and host='localhost';mysql> flush privileges;mysql> exit |
6.設置開機自啟動
| chkconfig mysql onchkconfig --list | grep mysqlmysql 0:off 1:off 2:on 3:on 4:on 5:on 6:off |
7.MySQL的默認安裝位置
| /var/lib/mysql/ #數據庫目錄/usr/share/mysql #配置文件目錄/usr/bin #相關命令目錄/etc/init.d/mysql #啟動腳本 |
8.常用命令
1.使用客戶端工具連接到數據庫
| mysql -u root -p |
2.查看MySQL服務器中包含那些數據庫
| mysql>SHOW DATABASES; |
3.查看數據庫中的數據表信息
| mysql>SHOW TABLES; |
4.切換數據庫
| mysql>USE mysql; |
5.創建新的數據庫
| mysql>CREATE DATABASE 數據庫名字; |
