Linux下bin方式安装MYSQL

Linux下bin方式安装MYSQL

 

1、  bin文件下载

地址 http://dev.mysql.com/downloads/mysql

2、  上传到服务器上

3、  解压到文件夹下

 

4、  创建用户

groupadd mysql

5、  创建用户组

useradd –r –g mysql mysql

6、  解压文件

tar zxvf mysql-5.6.12-linux-glibc2.5-x86_64.tar.gz

 

ln –s mysql-5.6.12-linux-glibc2.5-x86_64 mysql

 

7、  授权

cd mysql

chown –R mysql

chgrp –R mysql

8、  初始化数据库

scripts/mysql_install_db --user=mysql –ldata=XXXXXX

9、  变更权限

chown -R root .

chown –R mysql data

10、              修改配置文件

cp support-files/my-medium.cnf /etc/my.cnf

 

11、              启动数据库

./bin/mysqld_safe --basedir=/home/mysql/mysql-5.6.12-linux-glibc2.5-x86_64 --user=mysql --datadir=/home/mysql/data --port=4036

12、              数据库内操作

[root@dfsslave02 ~]# su - mysql

-bash-4.1$ mysql

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 2

Server version: 5.6.12-log MySQL Community Server (GPL)

 

Copyright (c) 2000, 2013, 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> UPDATE mysql.user SET Password = PASSWORD('123456') WHERE User = 'root';

Query OK, 4 rows affected (0.02 sec)

 

mysql> DELETE from mysql.user WHERE User=' ';

Query OK, 2 rows affected (0.03 sec)

 

mysql> flush privileges;

Query OK, 0 rows affected (0.02 sec)

 

mysql> grant all privileges on *.* to 'root'@'%' identified by '123456' with grant option;

Query OK, 0 rows affected (0.01 sec)

 

mysql> flush privileges;

Query OK, 0 rows affected (0.00 sec)