Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

CentOS6.8 x86_64bit source code installation MySQL-5.5.47

2025-03-30 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)06/01 Report--

Mysql-5.5.47 installation

1. Download the source code package in advance or go to the server to upload the source code package and decompress it

Cd / home/rich/tools

Rz-y "mysql-5.5.47-linux2.6-x86_64.tar.gz"

Tar xf mysql-5.5.47-linux2.6-x86_64.tar.gz

two。 Create an administrative user for the mysql database and check the

Useradd-s / sbin/nologin mysql-M

Id mysql

3. Move or copy the extracted source package to a directory that is easy for you to manage and create a software link

Mv mysql-5.5.57-linux-glibc2.12-i686 / application/mysql-5.5.57

Ln-s / application/mysql-5.5.57/ / application/mysql

4. Directory where the authorized user mysql manages the mysql

Cd / application/mysql

Chown-R mysql.mysql / application/mysql/

5. Enter the mysql directory to initialize the database

. / scripts/mysql_install_db-- basedir=/application/mysql/-- datadir=/application/mysql/data/-- user=mysql

6. Default startup directory for busier startup script files

Cd / application/mysql/bin/

Sed-I's instant mysqld_safe use rqqqr localcosmogram

7. Copy the mysql configuration file my.cnf to the server's configuration directory

Cd / application/mysql

\ cp support-files/my-small.cnf / etc/my.cnf

8. Because of the environment variable, it is impossible to start the mysql database by typing mysql directly on the command line, so specify the startup directory file of mysql to the environment variable of the server

Vi / etc/profile / / Edit the configuration file of boot self-startup

PATH= "/ application/mysql/bin:$PATH" > > / etc/profile / / add the startup directory file of mysql to the environment variable

. / etc/profile / / Command Line execution takes effect

9. Modify the installation directory customized by mysql in the startup script

Cd / application/mysql

Sed-I's tracing support-files/mysql.server usrplash localmarker

10. Copy the startup script to the server's startup script directory and rename it to mysqld

Cp support-files/mysql.server / etc/init.d/mysqld

Chmod + x / etc/init.d/mysqld / / add executable permissions to mysqld

11. Start and stop the mysql database

/ etc/init.d/mysqld start

/ etc/init.d/mysqld stop

twelve。 Check whether mysql starts successfully

Lsof-I: 3306 / / default port 3306 for mysql

13. Add mysqld to boot self-boot

Chkconfig-add mysqld

14. Create a login password for mysql data and log in using the password

Mysqladmin password 123456

Mysql-uroot-pendant 123456'

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report