Linux平台中Mysql安装-二进制方式

操作系统：RHEL6.4x64

Mysql版本：mysql-5.7.12-linux-glibc2.5-x86_64.tar.gz

规划：

安装流程

1.创建用户

groupadd mysql

useradd -g mysql mysql

2.解压安装包，并且拷贝到/usr/local/mysql目录，安装数据库

tar xvf mysql-5.7.12-linux-glibc2.5-x86_64.tar.gz

解压后会生成mysql-5.7.12-linux-glibc2.5-x86_64目录

cp -rfp  mysql-5.7.12-linux-glibc2.5-x86_64.tar.gz  /usr/local/mysql

 

[root@testmysql]# pwd /usr/local/mysql [root@test mysql]# ll total 52 drwxr-xr-x  2 7161 wheel  4096 Mar 28  2016 bin -rw-r--r--  1 7161 wheel 17987 Mar 28  2016 COPYING drwxr-xr-x  2 7161 wheel  4096 Mar 28  2016 docs drwxr-xr-x  3 7161 wheel  4096 Mar 28  2016 include drwxr-xr-x  5 7161 wheel  4096 Mar 28  2016 lib drwxr-xr-x  4 7161 wheel  4096 Mar 28  2016 man -rw-r--r--  1 7161 wheel  2478 Mar 28  2016 README drwxr-xr-x 28 7161 wheel  4096 Mar 28  2016 share drwxr-xr-x  2 7161 wheel  4096 Mar 28  2016 support-files [root@test mysql]# cd bin [root@test bin]# ls innochecksum       mysql                       mysqld          mysqlimport                mysql_ssl_rsa_setup  resolveip lz4_decompress     mysqladmin                  mysqld-debug    mysql_install_db           mysqltest_embedded   resolve_stack_dump myisamchk          mysqlbinlog                 mysqld_multi    mysql_plugin               mysql_tzinfo_to_sql  zlib_decompress myisam_ftdump      mysqlcheck                  mysqld_safe     mysqlpump                  mysql_upgrade myisamlog          mysql_client_test_embedded  mysqldump       mysql_secure_installation  mysqlxtest myisampack         mysql_config                mysqldumpslow   mysqlshow                  perror my_print_defaults  mysql_config_editor         mysql_embedded  mysqlslap                  replace [root@test bin]# ./mysql_install_db --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data 执行 ./mysql_install_db --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data命令后，会自动在basedir中生产data目录，并且创建数据库

3.修改属组

chown -R mysql.mysql  /usr/local/mysql

4.拷贝mysql.server以及配置my.cnf

cd /usr/local/mysql/support-files

 cp -rfp mysql.server /etc/init.d/mysqld

vi /etc/my.cnf

 

[mysqld] port=3306 basedir=/usr/local/mysql/ datadir=/usr/local/mysql/data/

 

注册mysql服务

 

chkconfig myqld on

chkconfig --list mysqld
mysqld          0:off   1:off   2:on    3:on    4:on    5:on    6:off

启动数据库

 service mysqld start
Starting MySQL.[  OK  ]

5.登录数据库

数据库安装好后，如果需要直接在终端中输入mysql登录mysql需要在环境变量中注册mysql的环境变量

echo "export PATH=/usr/local/mysql/bin:\$PATH"  >>  /etc/profile

which mysql
/usr/local/mysql/bin/mysql

 

登录数据库

mysql5.7安装完成后，会在/root/下生产密码文件

cat /root/.mysql_secret
# Password set for user 'root@localhost' at 2017-06-14 16:07:35
9NCpwC.y-5+E

终端中输入 mysql -p9NCpwC.y-5+E

即可登录数据库

登录数据库需要通过alert命令修改密码才能进行操作

mysql> show databases;
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.+

修改数据库密码

mysql> alter user 'root'@'localhost' identified by '12345';
Query OK, 0 rows affected (0.00 sec)

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
4 rows in set (0.00 sec)

mysql>
以上操作完成整个数据库的安装，初次安装，在此记录，如果问题，请留言指正，谢谢！