ubuntu14.04安装mysql5.6

悠悠 2022-08-27 11:56 151阅读 0赞

我觉得很郁闷，写好之后保存发表显示

![SouthEast][]

所以我一步一步的保存，看看是哪里被禁用了。

第一步下载：  
网址dev.mysql.com/downloads/mysql/  
在Select Platform:选择Linux-Generic  
下面会有很多下载安装包，我们选择最下面的**Linux - Generic (glibc 2.5) (x86, 64-bit), Compressed TAR Archive**，如果你的系统是32位，就选择**Linux - Generic (glibc 2.5) (x86, 32-bit), Compressed TAR Archive**。

第二步解压到指定目录  
例如我的下载包在/home/下载/mysql-5.6.19-linux-glibc2.5-x86\_64.tar.gz,我要把它安装到/opt/mysql5.6下，那么我要执行的命令如下  
sudo cd /home/下载  
sudo tar -zxvf mysql-5.6.19-linux-glibc2.5-x86\_64.tar/gz  
sudo mv mysql-5.6.19-linux-glibc2.5-x86\_64 /opt/mysql5.6

第三步创建用户组和用户  
这一步主要是为了安全起见，执行命令  
sudo groupadd mysql，可能会提示使用apt-get install \[指定的安装包\]，这时按提示执行命令sudo apt-get install mysql5.6，yes or no的时候选择y就好。  
然后我们就可以创建用户和组了,各命令的意思在上一篇已经介绍了。  
sudo groupadd mysql  
sudo useradd -r -g mysql mysql

第四步更改权限(注意mysql后面有一个空格，再跟一个.)

sudo cd  /opt/mysql5.6

sudo chown -R mysql .

sudo chgrp -R mysql .

第五步初始化mysql授权表

sudo script/mysql\_install\_db --user=mysql

第五步修改配置文件my.cnf

sudo geidt my.cnf

我修改之后的配置文件如下：

\# For advice on how to change settings please see

就是这个配置文件里面的一个地址我用图片来代替

![SouthEast 1][]

\[mysqld\]

\# Remove leading \# and set to the amount of RAM for the most important data

\# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.

innodb\_buffer\_pool\_size = 128M

\# Remove leading \# to turn on a very important data integrity option: logging

\# changes to the binary log between backups.

\# log\_bin

\# These are commonly set, remove the \# and set as required.

basedir = /opt/mysql5.6

datadir = /opt/mysql5.6/data

port = 3306

\# server\_id = .....

\# socket = .....

\# Remove leading \# to set options mainly useful for reporting servers.

\# The server defaults are faster for transactions and fast SELECTs.

\# Adjust sizes as needed, experiment to find the optimahttps://note.wiz.cn/web?cmd=ca%2C%2FMy%20Notes%2Fubuntu%2F%E7%8E%AF%E5%A2%83%E6%90%AD%E5%BB%BA%2F&dc=495ac518-4ad9-5c09-91dc-82447b1dbe8f&kb=c3f3e7c3-7b4b-4b00-a45c-0a3edad016fel values.

join\_buffer\_size = 128M

sort\_buffer\_size = 2M

read\_rnd\_buffer\_size = 2M

sql\_mode=NO\_ENGINE\_SUBSTITUTION,STRICT\_TRANS\_TABLES

第七步直接使用/etc/mysql/debian.cnf文件中\[client\]节提供的用户名和密码，下面是我使用其登录的结果。  
licheng@licheng-Aspire-4752:~$ mysql -udebian-sys-maint -p  
Enter password:   
Welcome to the MySQL monitor.  Commands end with ; or \\g.  
Your MySQL connection id is 37  
Server version: 5.6.17-0ubuntu0.14.04.1 (Ubuntu)  
  
Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.  
  
Oracle is a registered trademark of Oracle Corporation and/or its  
affiliates. Other names may be trademarks of their respective  
owners.  
  
Type 'help;' or '\\h' for help. Type '\\c' to clear the current input statement.  
  
mysql>   
  
第八步连接数据库  
mysql> show databases;  
\+--------------------+  
| Database           |  
\+--------------------+  
| information\_schema |  
| mysql              |  
| performance\_schema |  
\+--------------------+  
3 rows in set (0.00 sec)  
  
mysql> use mysql  
Reading table information for completion of table and column names  
You can turn off this feature to get a quicker startup with -A  
  
Database changed  
  
第九步修改密码  
mysql> update user set password='licheng888' where user='root';  
Query OK, 4 rows affected (0.01 sec)  
Rows matched: 4  Changed: 4  Warnings: 0  
  
第十步退出并使用新用户名和密码登录  
mysql> exit  
Bye  
licheng@licheng-Aspire-4752:~$ mysql -uroot -p  
Enter password:   
Welcome to the MySQL monitor.  Commands end with ; or \\g.  
Your MySQL connection id is 38  
Server version: 5.6.17-0ubuntu0.14.04.1 (Ubuntu)  
  
Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.  
  
Oracle is a registered trademark of Oracle Corporation and/or its  
affiliates. Other names may be trademarks of their respective  
owners.  
  
Type 'help;' or '\\h' for help. Type '\\c' to clear the current input statement.  
  
mysql>  
到此为止，大功告成。

[SouthEast]: /images/20220824/cb884ea8244e4cc88f5899f53da6b16a.png
[SouthEast 1]: /images/20220824/1ba43e497aac4426a935d065f0d37d52.png