一、安装cmake
1、解压cmake压缩包
[root@mysql tools]# tar -zvxf cmake-2.8.8.tar.gz [root@mysql tools]# ls cmake-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 toolchain C compiler on this system is: gcc C++ compiler on this system is: g++ Makefile processor on this system is: gmake g++ is GNU compiler g++ has STL in std:: namespace g++ has ANSI streams g++ has streams in std:: namespace
3、安装
[root@mysql cmake-2.8.8]# echo $"color: #ff0000">二、开始安装mysql1、首先需要安装(ncurses-devel)依赖包
[root@mysql cmake-2.8.8]# cd … [root@mysql tools]# yum -y install ncurses-devel Loaded plugins: fastestmirror Loading mirror speeds from cached hostfile base: mirrors.zju.edu.cn extras: centos.ustc.edu.cn updates: mirrors.zju.edu.cn Resolving 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-devel ncurses-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]# ls cmake-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 mysql uid=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=05、安装
[root@mysql mysql-5.5.16]# make && make install Scanning dependencies of target INFO_BIN [ 0%] Built target INFO_BIN Scanning dependencies of target INFO_SRC [ 0%] Built target INFO_SRC Scanning dependencies of target abi_check [ 0%] Built target abi_check Scanning dependencies of target zlib6、创建软连接
[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/profile export 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 0 drwxr-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=mysql Installing MySQL system tables… OK Filling 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 mysqld Note: This output shows SysV services only and does not include native systemd services. SysV configuration data might be overridden by native systemd 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 start Starting MySQL… SUCCESS! [root@mysql mysql-5.5.16]#12、查看端口进程
[root@mysql mysql-5.5.16]# lsof -i:3306 COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME mysqld 51146 mysql 10u IPv4 82600 0t0 TCP :mysql (LISTEN) [root@mysql mysql-5.5.16]# netstat -lnutp|grep 3306 tcp 0 0 0.0.0.0:3306 0.0.0.0: LISTEN 51146/mysqld [root@mysql mysql-5.5.16]# ps -ef|grep 3306 mysql 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=3306 root 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 mysql mysql> 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'总结
以上所述是小编给大家介绍的linux下使用cmake编译安装mysql的详细教程,希望对大家有所帮助,如果大家有任何疑问请给我留言,小编会及时回复大家的。在此也非常感谢大家对网站的支持!
如果你觉得本文对你有帮助,欢迎转载,烦请注明出处,谢谢!
RTX 5090要首发 性能要翻倍!三星展示GDDR7显存
三星在GTC上展示了专为下一代游戏GPU设计的GDDR7内存。
首次推出的GDDR7内存模块密度为16GB,每个模块容量为2GB。其速度预设为32 Gbps(PAM3),但也可以降至28 Gbps,以提高产量和初始阶段的整体性能和成本效益。
据三星表示,GDDR7内存的能效将提高20%,同时工作电压仅为1.1V,低于标准的1.2V。通过采用更新的封装材料和优化的电路设计,使得在高速运行时的发热量降低,GDDR7的热阻比GDDR6降低了70%。
更新日志
- 群星.1995-烧得厉害VOL.4两个世界【滚石】【WAV+CUE】
- 归龙潮中浦城区宝箱位置收集大全 中浦区宝箱解密攻略
- 黑神话悟空上品幽灯鬼精魄获取方法一览|上品幽灯鬼精魄收集攻略
- 《电锯糖心:RePOP》发售首日表现亮眼,玩家峰值超越《星鸣特攻》
- NewViennaOctet,ViennaWindSoloists-TheDeccaRecordings(2024)18CD[FLAC]-8
- 金梅子-《靓声妹3又见炊烟》[WAV+CUE]
- 杨阳《约定HQCDII》头版限量编号2024[WAV+CUE]
- 曝《黑神话:悟空》DLC明年推出 农历新年前后
- PS5日本涨价19% 索尼股价应声上涨2.7%
- 《黑神话》发行平台遭大规模网攻 外媒却鲜有报道
- 伍佰《爱你伍佰年 世纪典藏原音精选3CD》[WAV+CUE][2.3GB]
- 伍佰《爱情的尽头》[WAV+CUE][2.6GB]
- 伍佰 《光环摇滚之声DSD》[WAV+CUE][500MB]
- 王菲.1999-只爱陌生人【EMI百代】【WAV+CUE】
- 林美音.1993-酒后的心声【瑞华】【WAV+CUE】