方法：1、安装ncurses-devel依赖包；2、下载并解压mysql压缩包；3、使用cd命令进入mysql文件夹，使用cmake命令进行配置解析；4、使用“make && make install”命令安装mysql即可。
（推荐教程：mysql视频教程）
一、安装cmake
1、解压cmake压缩包
[root@mysql tools]# tar -zvxf cmake-2.8.8.tar.gz[root@mysql tools]# lscmake-2.8.8 cmake-2.8.8.tar.gz mysql-5.5.16.tar.gz scripts
2、解析
[root@mysql tools]# cd cmake-2.8.8[root@mysql cmake-2.8.8]# ./configure---------------------------------------------cmake 2.8.8, copyright 2000-2009 kitware, inc.found gnu toolchainc compiler on this system is: gccc++ compiler on this system is: g++makefile processor on this system is: gmakeg++ is gnu compilerg++ has stl in std:: namespaceg++ has ansi streamsg++ has streams in std:: namespace
3、安装
[root@mysql cmake-2.8.8]# echo $?0#如果返回值是0，就是执行成功，如果返回值是1，就是执行失败；[root@mysql cmake-2.8.8]# gmake && gmake installscanning dependencies of target cmiml_test[ 1%] building c object utilities/kwiml/test/cmakefiles/cmiml_test.dir/test.c.o[ 1%] building c object utilities/kwiml/test/cmakefiles/cmiml_test.dir/test_abi_c.c.o[ 1%] building c object utilities/kwiml/test/cmakefiles/cmiml_test.dir/test_int_c.c.o[ 1%] building c object utilities/kwiml/test/cmakefiles/cmiml_test.dir/test_include_c.c.o[ 2%] building cxx object utilities/kwiml/test/cmakefiles/cmiml_test.dir/test_abi_cxx.cxx.o[ 2%] building cxx object utilities/kwiml/test/cmakefiles/cmiml_test.dir/test_int_cxx.cxx.o[ 2%] building cxx object utilities/kwiml/test/cmakefiles/cmiml_test.dir/test_include_cxx.cxx.o
二、开始安装mysql
1、首先需要安装（ncurses-devel）依赖包
[root@mysql cmake-2.8.8]# cd …[root@mysql tools]# yum -y install ncurses-develloaded plugins: fastestmirrorloading mirror speeds from cached hostfilebase: mirrors.zju.edu.cnextras: centos.ustc.edu.cnupdates: mirrors.zju.edu.cnresolving dependencies–> running transaction check—> tools ncurses-devel.x86_64 0:5.9-14.20130511.el7_4 will be installed#############安装完成后检查###########[root@mysql tools]# rpm -qa | grep ncurses-develncurses-devel-5.9-14.20130511.el7_4.x86_64[root@mysql tools]#
2、解压mysql压缩包
[root@mysql tools]# tar -zvxf mysql-5.5.16.tar.gz[root@mysql tools]# lscmake-2.8.8 cmake-2.8.8.tar.gz mysql-5.5.16 mysql-5.5.16.tar.gz scripts[root@mysql tools]#
3、创建虚拟用户
[root@mysql tools]# useradd mysql -s /sbin/nologin -m[root@mysql tools]# id mysqluid=1000(mysql) gid=1000(mysql) groups=1000(mysql)[root@mysql tools]#
4、配置解析
[root@mysql tools]# cd mysql-5.5.16[root@mysql mysql-5.5.16]#[root@mysql mysql-5.5.16]# cmake . -dcmake_install_prefix=/usr/local/mysql-5.5.16 -dmysql_datadir=/usr/local/mysql-5.5.16/data -dmysql_unix_addr=/usr/local/mysql-5.5.16/tmp/mysql.sock -ddefault_charset=utf8 -ddefault_collation=utf8_general_ci -dextra_charsets=gbk,gb2312,utf8,ascii -denabled_local_infile=on -dwith_innobase_storage_engine=1 -dwith_federated_storage_engine=1 -dwith_blackhole_storage_engine=1 -dwithout_example_storage_engine=1 -dwithout_partition_storage_engine=1 -dwith_fast_mutexes=1 -dwith_zlib=bundled -denabled_local_infile=1 -dwith_readline=1 -dwith_embedded_server=1 -dwith_debug=0
5、安装
[root@mysql mysql-5.5.16]# make && make installscanning dependencies of target info_bin[ 0%] built target info_binscanning dependencies of target info_src[ 0%] built target info_srcscanning dependencies of target abi_check[ 0%] built target abi_checkscanning dependencies of target zlib
6、创建软连接
[root@mysql mysql-5.5.16]# ln -s /usr/local/mysql-5.5.16/ /usr/local/mysql[root@mysql mysql-5.5.16]# readlink /usr/local/mysql/usr/local/mysql-5.5.16/[root@mysql mysql-5.5.16]#
7、配置环境
[root@mysql mysql-5.5.16]# cd …[root@mysql tools]# echo ‘export path=/usr/local/mysql/bin:$path' >>/etc/profile[root@mysql tools]# tail -1 /etc/profileexport path=/usr/local/mysql/bin:$path[root@mysql tools]# source /etc/profile[root@mysql tools]# echo $path/usr/local/mysql/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/root/bin[root@mysql tools]#
8、拷贝、查看、设置属主、及添加tmp权限
[root@mysql tools]# \cp mysql-5.5.16/support-files/my-small.cnf /etc/my.cnf[root@mysql tools]# ll /usr/local/mysql/data/total 0drwxr-xr-x 2 root root 20 may 31 11:51 test[root@mysql tools]# chown -r mysql.mysql /usr/local/mysql/data/[root@mysql tools]# chmod -r 1777 /tmp/[root@mysql tools]#
9、初始化数据库
[root@mysql tools]# cd /usr/local/mysql/scripts/[root@mysql scripts]# ./mysql_install_db --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data/ --user=mysqlinstalling mysql system tables…okfilling help tables…ok
注：看到两个ok表示成功
10、设置开机启动
[root@mysql scripts]# cd /roottools/mysql-5.5.16[root@mysql mysql-5.5.16]# cp support-files/mysql.server /etc/init.d/mysqld[root@mysql mysql-5.5.16]# chmod -r 755 /etc/init.d/mysqld[root@mysql mysql-5.5.16]# chkconfig --add mysqld[root@mysql mysql-5.5.16]# chkconfig mysqld on[root@mysql mysql-5.5.16]# chkconfig --list mysqldnote: this output shows sysv services only and does not include nativesystemd services. sysv configuration data might be overridden by nativesystemd configuration.if you want to list systemd services use ‘systemctl list-unit-files'.to see services enabled on particular target use‘systemctl list-dependencies [target]'.mysqld 0:off 1:off 2:on 3:on 4:on 5:on 6:off[root@mysql mysql-5.5.16]#
11、启动mysql数据库
[root@mysql mysql-5.5.16]# /etc/init.d/mysqld startstarting mysql… success![root@mysql mysql-5.5.16]#
12、查看端口进程
[root@mysql mysql-5.5.16]# lsof -i:3306command pid user fd type device size/off node namemysqld 51146 mysql 10u ipv4 82600 0t0 tcp :mysql (listen)[root@mysql mysql-5.5.16]# netstat -lnutp|grep 3306tcp 0 0 0.0.0.0:3306 0.0.0.0: listen 51146/mysqld[root@mysql mysql-5.5.16]# ps -ef|grep 3306mysql 51146 50900 0 14:13 pts/1 00:00:00 /usr/local/mysql-5.5.16/bin/mysqld --basedir=/usr/local/mysql-5.5.16 --datadir=/usr/local/mysql-5.5.16/data --plugin-dir=/usr/local/mysql-5.5.16/lib/plugin --user=mysql --log-error=/usr/local/mysql-5.5.16/data/mysql.err --pid-file=/usr/local/mysql-5.5.16/data/mysql.pid --socket=/usr/local/mysql-5.5.16/tmp/mysql.sock --port=3306root 51170 16240 0 14:14 pts/1 00:00:00 grep --color=auto 3306[root@mysql mysql-5.5.16]#
注：如果要重新初始化只要删除data目录库文件存储地或者新建一个库文件存储地，重新初始化，提示两个ok就是成功
进入数据库
[root@localhost ~]# mysql
查看所有用户
mysql> use mysqlmysql> show tables;mysql> select user,host from user;
删除系统默认的
delete from mysql.user where user='';delete from mysql.user where host='::1';select user,host from mysql.user;
只保留这两个
mysql> select user,host from mysql.user;±-----±----------+| user | host |±-----±----------+| root | 127.0.0.1 || root | localhost |±-----±----------+2 rows in set (0.00 sec)mysql>#########################
添加额外的授权管理员用户
grant all privileges on . to system@‘192.168.%' identified by ‘system' with grant option;
字符集路径
vi /etc/locale.conf #centos7
mysql创建密码
/application/mysql//bin/mysqladmin -u root password ‘123456'
mysql修改密码
/application/mysql//bin/mysqladmin -u root -p123456 password ‘112233'
相关推荐：php培训
以上就是linux上怎么使用cmake安装mysql？的详细内容。