How to install mysql database in linux php-PHP Problem-php.cn

How to install mysql database in linux php: first turn off the Linux firewall; then download the appropriate mysql version from the mysql official website; then set the directory access permissions in the current mysql directory; finally check the mysql status. Can.

How to install mysql database in linux php

1. First, turn off the Linux firewall and execute the command

chkconfig iptables off

Copy after login

从mysql官网上下载自己适合的mysql版本

Copy after login

https://dev. mysql.com/downloads/mysql/5.6.html#downloads, enter the mysql official website, click

##3. Downloaded mysql file

mysql-5.6.40-linux-glibc2.12-i686.tar.gz

Copy after login

Place the downloaded mysql compressed file in the /usr/local folder of Linux, and decompress the compressed file

tar -zxvf mysql-5.6.40-linux-glibc2.12-i686.tar.gz

Copy after login

Rename the decompressed file to mysql

mv mysql-5.6.40-linux-glibc2.12-i686 mysql

Copy after login

4. Create mysql user group and user

groupadd mysql useradd -r -g mysql mysql

Copy after login

5. Enter the mysql directory and perform the operation of adding MySQL configuration

cp support-files/my-medium.cnf /etc/my.cnf 或： cp support-files/my-default.cnf /etc/my.cnf

Copy after login

是否覆盖？按y 回车

Copy after login

6. Edit the /etc/my.cnf file;

vi /etc/my.cnf

Copy after login

Add or modify relevant configurations in the my.cnf file, save and exit after the changes are completed

1 # For advice on how to change settings please see 2 # http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html 3 # *** DO NOT EDIT THIS FILE. It's a template which will be copied to the 4 # *** default location during install, and will be replaced if you 5 # *** upgrade to a newer version of MySQL. 6 7 [mysqld] 8 9 # Remove leading # and set to the amount of RAM for the most important data10 # cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.11 # innodb_buffer_pool_size = 128M12 13 # Remove leading # to turn on a very important data integrity option: logging14 # changes to the binary log between backups.15 # log_bin16 17 # These are commonly set, remove the # and set as required.18 basedir = /usr/local/mysql19 datadir = /usr/local/mysql/data20 port = 330621 # server_id = .....22 socket = /tmp/mysql.sock23 character-set-server = utf824 skip-name-resolve25 log-err = /usr/local/mysql/data/error.log26 pid-file = /usr/local/mysql/data/mysql.pid27 28 # Remove leading # to set options mainly useful for reporting servers.29 # The server defaults are faster for transactions and fast SELECTs.30 # Adjust sizes as needed, experiment to find the optimal values.31 # join_buffer_size = 128M32 # sort_buffer_size = 2M33 # read_rnd_buffer_size = 2M 34 35 sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

Copy after login

7. Set the access permissions of the directory in the current directory of mysql (note the small following) point, indicating the current directory)

chown -R mysql . chgrp -R mysql . scripts/mysql_install_db --user=mysql chown -R root . chown -R mysql data

Copy after login

8. Initialize data (there is a mysql_install_db executable file under mysql/bin or mysql/scripts to initialize the database), enter mysql/bin or mysql/ scripts directory, execute the following command

./mysql_install_db --verbose --user=root --defaults-file=/etc/my.cnf --datadir=/usr/local/mysql/data --basedir=/usr/local/mysql --pid-file=/usr/local/mysql/data/mysql.pid --tmpdir=/tmp

Copy after login

9. Start mysql, enter the /usr/local/mysql/bin directory, and execute the following command

./mysqld_safe --defaults-file=/etc/my.cnf --socket=/tmp/mysql.sock --user=root &

Copy after login

注意，如果光标停留在屏幕上，表示启动成功，需要我们先关闭shell终端，再开启一个新的shell终端，不要执行退出操作。如果出现 mysql ended这样的语句，表示Mysql没有正常启动，你可以到log中查找问题.

Copy after login

10. Set the boot time, new After opening the shell interrupt, enter the mysql directory and execute the following command

cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld cp /usr/local/mysql/support-files/mysql.server /etc/rc.d/init.d/mysql

Copy after login

chmod 700 /etc/init.d/mysql chkconfig --add mysqld chkconfig --level 2345 mysqld on chown mysql:mysql -R /usr/local/mysql/

Copy after login

Restart linux

reboot

Copy after login

View mysql status

service mysqld status

Copy after login

11. Add remote access permissions

(1) Add mysql command

ln -s /usr/local/mysql/bin/mysql /usr/bin （mysql的安装路径）

Copy after login

(2) Change access permissions

登录mysql,执行下面命令 mysql -uroot -p 密码为空直接回车,运行以下两条命令 GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'duan' with grant option; Flush privileges;

Copy after login

Exit mysql

exit

Copy after login

Restart linux and you are done

reboot

Copy after login

Note: To access mysql locally, the root account has no password by default, and the port number defaults to 3306. If you need to change the root account password, execute the following command in the /usr/local/mysql/bin directory

./mysqladmin -h 127.0.0.1 -P3306 -uroot password 'duan'exit

Copy after login

Update For more related knowledge, please visit

PHP中文网!

The above is the detailed content of How to install mysql database in linux php. For more information, please follow other related articles on the PHP Chinese website!