centos 新服务器安装二 mysql安装及配置

[root@localhost home]# yum install cmake
[root@localhost mysql-5.6.16]# yum install ncurses-devel

创建数据库数据存放目录
[root@localhost data]# mkdir -p /opt/wcare/mysql/data
[root@localhost data]# mkdir -p /var/lib/mysql
[root@localhost bin]# mkdir -p /var/run/mysqld

cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/opt/wcare/mysql/data -DMYSQL_UNIX_ADDR=/var/lib/mysql/mysql.sock -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_ARCHIVE_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 -DENABLED_LOCAL_INFILE=1 -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DEXTRA_CHARSETS=all -DMYSQL_TCP_PORT=3306

 

CMake Error: your CXX compiler: "CMAKE_CXX_COMPILER-NOTFOUND" was not found

如果遇到这个错误，找不到编译环境所需语言，需要#yum install gcc-c++

安装完后最好删除包，重新解压再cmake，否则可能make的时候会遇到

mysql编译 error: invalid conversion from ‘size_socket*问题。

 

make && make install

cd scripts
./mysql_install_db --user=root --datadir=/opt/wcare/mysql/data --basedir=/usr/local/mysql --defaults-file=/etc/my.cnf
执行该语句的时候可能会报一些错误，需要查看下/etc/my.cnf是否配置对。

修改/etc/my.cnf
#####################################################
[mysqld]
datadir=/opt/wcare/mysql/data
socket=/var/lib/mysql/mysql.sock
user=root
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
# Settings user and group are ignored when systemd is used.
# If you need to run mysqld under a different user or group,
# customize your systemd unit file for mariadb according to the
# instructions in http://fedoraproject.org/wiki/Systemd
log-bin=mysql-bin

[mysql]
socket=/var/lib/mysql/mysql.sock

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
#####################################################

执行脚本的时候如果报如下错误

Can't locate Data/Dumper.pm in @INC (@INC contains: /usr/local/lib64/perl5 /usr/local/share/perl5 /usr/lib64/perl5/vendor_perl /usr/share/perl5/vendor_perl /usr/lib64/perl5 /usr/share/perl5 .) at ./mysql_install_db line 42.

就执行如下语句，就会安装perl-Data-Dumper

# yum -y install autoconf

 

[root@localhost bin]# useradd mysql
[root@localhost bin]# vim /var/log/mysqld.log
[root@localhost bin]# chown -R mysql:mysql /var/lib/mysql

./mysqld_safe --defaults-file=/etc/my.cnf --basedir=/usr/local/mysql --datadir=/opt/wcare/mysql/data --collation-server=utf8_general_ci --user=root --socket=/var/lib/mysql/mysql.sock

然后启动mysql客户端修改密码：
./mysql  -uroot –p
直接按回车进入，无需设置密码，进入数据库，然后
use mysql;
修改密码，修改用户：
set password for root@'localhost' = password('12345')
set password for root@'127.0.0.1' = password('12345')

MySQL数据库远程访问权限设置
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'IDENTIFIED BY 'mypassword' WITH GRANT OPTION;
FLUSH PRIVILEGES

运行脚本 watchcare_server_db.sh，该脚本会创建需要使用到的数据库

等数据库创建好后，修改w01_init_db.sql配置，编辑数据库初始化需要的数据。
启动mysql客户端，进入：
mysql> source  w01_init_db.sql
导入系统需要使用的数据库配置。

 

数据库并发相关查询

当前连接数  mysql> show full processlist;

设置的最大连接数  mysql> show variables like '%max_connection%';

修改最大连接数  mysql> set global max_connections=1000

线程连接  mysql> show status like 'Threads%';