CenterOS6.5(Minimal) 搭建MySQL

最新推荐文章于 2021-09-06 17:22:31 发布

原创最新推荐文章于 2021-09-06 17:22:31 发布 · 654 阅读

0 ·

CC 4.0 BY-SA版权

Linux 专栏收录该内容

10 篇文章

订阅专栏

本文详细介绍了MySQL 5.6版本从源码包安装到配置运行的全过程，包括下载源码、编译安装、配置文件修改及数据库初始化等内容。

安装基础库请参考这里

MySQL

下载安装

wget http://cdn.mysql.com/Downloads/MySQL-5.5/mysql-5.6.19.tar.gz -P /usr/local/app/sources/
cd /usr/local/app/sources/
tar -xf mysql-5.6.19.tar.gz
cd mysql-5.6.19
cmake -DCMAKE_INSTALL_PREFIX=/usr/local/app/mysql
make
make install clean

配置修改

创建mysql用户和组 groupadd mysql, useradd -g mysql mysql
修改/usr/local/app/mysql的用户和组 chown -R mysql:mysql /usr/local/app/mysql
cp /usr/local/app/mysql/support-files/my-default.cnf /usr/local/app/mysql/my.cnf
my.cnf中增加如下内容

[mysqld]
basedir = /usr/local/app/mysql
datadir = /usr/local/app/mysql/data
port = 9001
server_id = 1
socket = /usr/local/app/mysql/data/mysqld.sock
pid-file = /usr/local/app/mysql/data/mysqld.pid

character-set-client-handshake = FALSE
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
init_connect='SET NAMES utf8mb4'

innodb_buffer_pool_size = 32M
innodb_log_group_home_dir = /usr/local/app/mysql/data

join_buffer_size = 8M
sort_buffer_size = 8M
read_rnd_buffer_size = 8M
general_log = 1
general_log_file = /usr/local/app/mysql/data/mysqld.log

log_bin = /usr/local/app/mysql/data/mysql-bin
log_error = /usr/local/app/mysql/data/mysqld-error.log
max_connections = 1000
long_query_time = 2
slow_query_log = 1
slow_query_log_file = /usr/local/app/mysql/data/mysqld-slow.log

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

[client]
default-character-set=utf8mb4
[mysql]
default-character-set = utf8mb4

/usr/local/app/mysql/scripts/mysql_install_db --user=mysql --basedir=/usr/local/app/mysql --datadir=/usr/local/app/mysql/data --explicit_defaults_for_timestamp
启动MySQL /usr/local/app/mysql/bin/mysqld_safe --defaults-file=/usr/local/app/mysql/my.cnf --user=mysql
连接mysql 配置用户密码等 /usr/local/app/mysql/bin/mysql -uroot -h127.0.0.1
创建一个数据库 create database dbname;
grant all privileges on dbname.* to mysqluser@’127.0.0.1’ identified by ‘mysqluserpasswd’;
commit;
flush privileges;
修改mysql管理帐户的密码(待补充)

测试

上个部分创建的数据库中创建一个表user并向其中插入几条数据
修改/home/www/app/index.php 为如下内容

$connect = mysqli_connect('127.0.0.1','mysqluser','123456', 'dbname') or die('Unale to connect');
$sql = "select * from user";
$result = mysqli_query($connect,$sql);
$response['index'] = array();
while($row = mysqli_fetch_assoc($result)){
    array_push($response['index'], $row);
}
echo json_encode($response);

在浏览器中查看结果