linux安装mysql5.6.27_Linux安装mysql5.6

1.安装cmake

yum -y install cmake

2.将mysql安装包剪切到/usr/local/src下

3.解压

4.cmake

cmake \

-DCMAKE_INSTALL_PREFIX=/usr/local/mysql \

-DMYSQL_DATADIR=/usr/local/mysql/data \

-DSYSCONFDIR=/etc \

-DWITH_MYISAM_STORAGE_ENGINE=1 \

-DWITH_INNOBASE_STORAGE_ENGINE=1 \

-DWITH_MEMORY_STORAGE_ENGINE=1 \

-DWITH_READLINE=1 \

-DMYSQL_UNIX_ADDR=/var/lib/mysql/mysql.sock \

-DMYSQL_TCP_PORT=3306 \

-DENABLED_LOCAL_INFILE=1 \

-DWITH_PARTITION_STORAGE_ENGINE=1 \

-DEXTRA_CHARSETS=all \

-DDEFAULT_CHARSET=utf8 \

-DDEFAULT_COLLATION=utf8_general_ci

linux安装mysql出现Could NOT find Curses (missing CURSES_LIBRARY CURSES_INCLUDE_PATH)，提示解决方法

rm CMakeCache.txt

yum install ncurses-devel

yum install gcc-c++

5.make && make install

6.添加用户

[root@localhost tmp]# groupadd mysql

[root@localhost tmp]# useradd -g mysql mysql

7.修改权限

chown -R mysql:mysql /usr/local/mysql

8.初始化数据库，创建系统自带的数据库和表

scripts/mysql_install_db --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --user=mysql

注：在启动MySQL服务时，会按照一定次序搜索my.cnf，先在/etc目录下找，找不到则会搜索"$basedir/my.cnf"，在本例中就是 /usr/local/mysql/my.cnf，这是新版MySQL的配置文件的默认位置！

注意：在CentOS 7版操作系统的最小安装完成后，在/etc目录下会存在一个my.cnf，需要将此文件更名为其他的名字，如：/etc/my.cnf.bak，否则，该文件会干扰源码安装的MySQL的正确配置，造成无法启动。

find / -name my.cnf

9.配置mysql服务

[root@localhost mysql]# cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql

[root@localhost mysql]# chkconfig mysql on

[root@localhost mysql]# service mysql start --启动MySQL

有可能会失败，进行下面的处理

[root@localhost etc]# mkdir -p /var/lib/mysql

[root@localhost etc]# chown mysql:mysql /var/lib/mysql

10.修改登录密码

/usr/local/mysql/bin/mysqld_safe --user=mysql &

mysql>use mysql; 选择数据库

Database changed

mysql> UPDATE user SET password=PASSWORD("新密码") WHERE user='你的用户名';

mysql> FLUSH PRIVILEGES;

mysql> quit;

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=PASSWORD("123456") WHERE user='root';

Query OK, 4 rows affected (0.03 sec)

Rows matched: 4 Changed: 4 Warnings: 0

mysql> FLUSH PRIVILEGES;

Query OK, 0 rows affected (0.00 sec)

mysql> quit;

11.设置外部访问

mysql> grant all privileges on *.* to root@"192.168.1.88" identified by "123456";

Query OK, 0 rows affected (0.00 sec)

mysql> flush privileges;

Query OK, 0 rows affected (0.00 sec)

mysql> select user,host from user;