mysql-5.1.72安装配置
admin
2023-05-08 17:42:02
0

一、系统环境
a、系统Centos 6.5 X64位

[root@mytest ~]# uname -a
Linux mytest 2.6.32-431.el6.x86_64 #1 SMP Fri Nov 22 03:15:09 UTC 2013 x86_64 x86_64 x86_64 GNU/Linux

mysql 文件包: mysql-5.1.72
b、需要软件
mysql-5.1.72.tar ncurses.tar
二,安装
对下载的包进行解压操作安装:

[root@myser tools]# tar xf mysql-5.1.72.tar.gz
[root@myser alidata]# ls  
mysql-5.1.72  mysql-5.1.72.tar.gz
[root@myser tools]# cd mysql-5.1.72  

[root@myser mysql-5.1.72]# ./configure --prefix=/application/mysql
在安装的这里会报错,提示
checking for termcap functions library... configure: error: No curses/termcap library found

提示缺少curses程序,
[root@myser mysql-5.1.72]# yum install ncurses-devel -y
然后在重新运行上面安装的命令。
[root@myser mysql-5.1.72]# ./configure --prefix=/application/mysql
。。。
。。
/bin/rm: cannot remove `libtoolT': No such file or directory
config.status: executing default commands

Thank you for choosing MySQL!

Remember to check the platform specific part of the reference manual
for hints about installing MySQL on your platform.
Also have a look at the files in the Docs directory.
提示已经安装完成,
现在进行编译
[root@myser mysql-5.1.72]# make &&make install #这步时间会很长
[root@myser support-files]# pwd
/root/alidata/mysql-5.1.72/support-files
[root@myser mysql-5.1.72]# cd support-files/
[root@myser support-files]# cp my-small.cnf /etc/my.cnf
cp: overwrite /etc/my.cnf'? y
[root@myser support-files]# cp mysql.server.sh /etc/init.d/mysqld
[root@myser support-files]# mkdir /application/mysql/data #创建mysql数据文件存放目录
[root@myser support-files]# groupadd mysql #创建mysql组
[root@myser support-files]# useradd -g mysql -M -s /sbin/nologin #创建mysql用户属于mysql组,且不配置家目录并且不登录
[root@myser support-files]# chown -R mysql.mysql /application/mysql/ #配置data 目录权限

三,对数据库初始化操作
[root@myser support-files]# /application/mysql/bin/mysql_install_db --basedir=/application/mysql/ --datadir=/application/mysql/data/ --user=mysql
WARNING: The host 'myser' could not be looked up with resolveip.
This probably means that your libc libraries are not 100 % compatible
with this binary MySQL version. The MySQL daemon, mysqld, should work
normally with the exception that host name resolving will not work.
This means that you should use IP addresses instead of hostnames
when specifying MySQL privileges !
Installing MySQL system tables...
180102 16:43:02 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
OK
Filling help tables...
180102 16:43:03 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
OK

To start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:

/application/mysql//bin/mysqladmin -u root password 'new-password'
/application/mysql//bin/mysqladmin -u root -h myser password 'new-password'

Alternatively you can run:
/application/mysql//bin/mysql_secure_installation

which will also give you the option of removing the test
databases and anonymous user created by default. This is
strongly recommended for production servers.

See the manual for more instructions.

You can start the MySQL daemon with:
cd /application/mysql/ ; /application/mysql//bin/mysqld_safe &

You can test the MySQL daemon with mysql-test-run.pl
cd /application/mysql//mysql-test ; perl mysql-test-run.pl

Please report any problems with the /application/mysql//scripts/mysqlbug script!

[root@myser support-files]# /application/mysql/bin/mysqld_safe & 启动数据库
[1] 52951
[root@myser support-files]# 180102 16:44:20 mysqld_safe Logging to '/application/mysql/data/myser.err'.
180102 16:44:20 mysqld_safe Starting mysqld daemon with databases from /application/mysql/data
查看是否启动并检查端口
[root@myser support-files]# netstat -lntpu|grep mysql
tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN 53056/mysqld

[root@myser support-files]# chkconfig --add mysqld   
[root@myser support-files]# chkconfig mysqld on   
[root@myser support-files]# chmod +x /etc/init.d/mysqld 

mysql的结束进程
[root@myser support-files]# pkill mysql

第二种启动mysql
先对mysql文件进行编辑
[root@myser tmp]# vi /etc/init.d/mysqld
# overwritten by settings in the MySQL configuration files.

basedir=/application/mysql
datadir=/application/mysql/data

# Default value, in seconds, afterwhich the script should timeout waiting
# for server start.

[root@myser tmp]# vi /etc/profile
PATH="/application/mysql/bin/:$PATH" #添加到文件结尾:
[root@myser tmp]# source /etc/init.d/mysqld
[root@myser tmp]# /etc/init.d/mysqld start
/etc/init.d/mysqld: line 270: @HOSTNAME@: command not found
/etc/init.d/mysqld: line 279: @HOSTNAME@: command not found
Starting MySQL. SUCCESS!
[root@myser tmp]# /etc/init.d/mysqld stop
/etc/init.d/mysqld: line 270: @HOSTNAME@: command not found
/etc/init.d/mysqld: line 279: @HOSTNAME@: command not found
Shutting down MySQL. SUCCESS!
[root@myser tmp]# netstat -lntp
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name
tcp 0 0 0.0.0.0:22 0.0.0.0: LISTEN 1368/sshd
tcp 0 0 0.0.0.0:9191 0.0.0.0:
LISTEN 1354/procstart

相关内容

热门资讯

凤凰独家:特朗普二儿子与夫人参... 凤凰独家报道,中美元首会谈期间,特朗普二儿子埃里克·特朗普与夫人参观人民大会堂,并在《江山如此多娇》...
联合国赞赏中美就伊朗问题保持沟... 联合国秘书长古特雷斯13日通过副发言人哈克表示,欢迎中美元首会晤,赞赏两国通过对话沟通妥善处理分歧。...
特稿|拉长合作清单 贡献建设性... 新华社北京5月13日电 题:拉长合作清单 贡献建设性力量——美国商学界人士瞩望美中经贸关系互利共赢新...
中国量子计算新突破!“九章四号... 记者从中国科学技术大学获悉,由该校潘建伟院士领衔的科研团队联合国内多家科研机构、大学,近期成功研制出...
跳河救人的外卖小哥找到了! 外... 5月12日下午5时许,漯河市郾城区孟庙镇幸福渠河堤旁,57岁的甘女士蹲在河边打水,准备回家给鱼换水,...
今年以来,越来越多美国交流团来... 4月,数十名美国犹他州青少年来豫参加2026年YES项目交流活动。图为美国青少年在郑州体验书法项目。...
“打工机器人”亮相郑州街头 机器人服务员“小盖”在郑州街边的一零售店工作。 王磊 摄机器人当服务员,在街头卖咖啡——这不是科幻电...
打响“河南服务”品牌丨盾构机有... 【开栏的话】为深入贯彻落实全省服务业大会精神,本报即日起开设“打响‘河南服务&rsquo...
一季度我国数字产业收入9.5万... 【大河财立方消息】5月14日,工信部发布的数据显示,一季度,我国数字产业实现良好开局,行业利润大幅改...
一体推进整治形式主义为基层减负... 形式主义实质是主观主义、功利主义,根源是政绩观错位、责任心缺失。当前,各地以深化“六个纠治”为抓手,...