Système d'exploitation Linux : centOS6.5 64 bits (package de développement par défaut du système installé)
Base de données 1 :
Version MYSQL : mysql-5.0.56
PORT:3306
Répertoire système : /usr/local/mysql3306
Base de données 2 :
Version MYSQL : mysql-5.1.72
PORT:3307
Répertoire système :/usr/local/mysql3307
<pre name="code" class="plain"># yum -y install wget gcc-c++ ncurses ncurses-devel cmake make perl bison openssl openssl-devel gcc* libxml2 libxml2-devel curl-devel libjpeg* libpng* freetype*
# service iptables stop # setenforce 0 # vi /etc/sysconfig/selinux --------------- SELINUX=disabled
# su - # mkdir ~/src # cd src # wget //m.sbmmt.com/ # wget //m.sbmmt.com/
# useradd mysql
# mkdir -p /usr/local/mysql{3306,3307}/data
# mkdir -p /usr/local/mysql{3306,3307}/log# chown -R mysql:mysql /usr/local/mysql{3306,3307}/data/
# chown -R mysql:mysql /usr/local/mysql{3306,3307}/log/
# chmod 750 /usr/local/mysql{3306,3307}/data
# chmod 750 /usr/local/mysql{3306,3307}/log# mkdir -p /usr/local/mysql{3306,3307}/etc
# chown -R mysql.mysql /usr/local/mysql{3306,3307}/etc
# mkdir -p /var/run/mysqld{3306,3307}
# chown -R mysql.mysql /var/run/mysqld{3306,3307}
# mkdir -p /var/lib/mysqld{3306,3307}
# chown -R mysql.mysql /var/lib/mysqld{3306,3307}
# cp /etc/my.cnf /usr/local/mysql{3306,3307}/etc# cd ~/src # tar -zxvf mysql-5.0.56.tar.gz # cd mysql-5.0.56 ./configure --prefix=/usr/local/mysql3306 --with-mysqld-user=mysql --sysconfdir=/usr/local/mysql3306/etc --localstatedir=/usr/local/mysql3306/data --with-tcp-port=3306 -enable-assembler --with-mysqld-ldflags=-all-static --with-charset=utf8 --with-extra-charsets=utf-8 -with-extra-charsets=all --with-plugins=csv,innobase,myisam,heap --with-unix-socket-path=/tmp/mysql3306.sock # make # make install
# cd ~/src # tar -zxvf mysql-5.1.71.tar.gz # cd mysql-5.1.71 ./configure --prefix=/usr/local/mysql3307 --with-mysqld-user=mysql --sysconfdir=/usr/local/mysql3307/etc --localstatedir=/usr/local/mysql3307/data --with-tcp-port=3307 -enable-assembler --with-mysqld-ldflags=-all-static --with-charset=utf8 --with-extra-charsets=utf-8 -with-extra-charsets=all --with-plugins=csv,innobase,myisam,heap --with-unix-socket-path=/tmp/mysql3307.sock # make # make install
# vi /usr/local/mysql3306/etc/my.cnf ------------------------------------------------------- [mysqld] datadir=/usr/local/mysql3306/data socket=/tmp/mysql3306.sock user=mysql port=3306 pid-file=/var/lib/mysqld3306/mysql.pid # Disabling symbolic-links is recommended to prevent assorted security risks symbolic-links=0 max_connections= 16384 skip-name-resolve skip-locking key_buffer = 256M max_allowed_packet = 32M table_cache = 3072 thread_cache_size = 256 sort_buffer_size = 16M read_buffer_size = 4M read_rnd_buffer_size = 16M net_buffer_length = 256M thread_stack = 8M query_cache_size = 128M query_cache_limit = 2M wait_timeout=7200 interactive_timeout=7200 #log log-error=/usr/local/mysql3306/log/error.log log=/usr/local/mysql3306/log/mysql.log long_query_time=2 log-slow-queries= /usr/local/mysql3306/log/slowquery.log log-bin= /usr/local/mysql3306/log/bin.log expire_logs_days = 15 sync_binlog = 1 max_binlog_cache_size = 4294967295 local-infile=0 default-storage-engine=INNODB [mysqld_safe] log-error=/var/log/mysqld3306.log pid-file=/var/run/mysqld3306/mysqld.pid
# vi /usr/local/mysql3307/etc/my.cnf ------------------------------------------------------- [mysqld] datadir=/usr/local/mysql3307/data socket=/tmp/mysql3307.sock user=mysql port=3307 pid-file=/var/lib/mysqld3307/mysql.pid # Disabling symbolic-links is recommended to prevent assorted security risks symbolic-links=0 max_connections= 16384 skip-name-resolve skip-locking key_buffer = 256M max_allowed_packet = 32M table_cache = 3072 thread_cache_size = 256 sort_buffer_size = 16M read_buffer_size = 4M read_rnd_buffer_size = 16M net_buffer_length = 256M thread_stack = 8M query_cache_size = 128M query_cache_limit = 2M wait_timeout=7200 interactive_timeout=7200 #log log-error=/usr/local/mysql3307/log/error.log log=/usr/local/mysql3307/log/mysql.log long_query_time=2 log-slow-queries= /usr/local/mysql3307/log/slowquery.log log-bin= /usr/local/mysql3307/log/bin.log expire_logs_days = 15 sync_binlog = 1 max_binlog_cache_size = 4294967295 local-infile=0 default-storage-engine=INNODB [mysqld_safe] log-error=/var/log/mysqld3307.log pid-file=/var/run/mysqld3307/mysqld.pid -------------------------------------------------------
# ln -s /usr/local/mysql3306/lib/mysql /usr/lib/mysql
# echo "/usr/local/mysql3306/lib" >> /etc/ld.so.conf.d/mysql.conf # ldconfig
# ln -s /usr/local/mysql3306/include/mysql /usr/include/mysql
plusieurs. 7. Saisissez le chemin d'installation de l'instance correspondante, Initialisez les scripts de configuration respectifs
# cd /usr/local/mysql3306 # scripts/mysql_install_db --user=mysql --datadir=/usr/local/mysql3306/data
# cd /usr/local/mysql3307 # scripts/mysql_install_db --user=mysql --datadir=/usr/local/mysql3307/data
# cp /usr/local/mysql3306/support-files/mysql.server /etc/init.d/mysqld3306 # cp /usr/local/mysql3307/support-files/mysql.server /etc/init.d/mysqld3307
# vi /etc/init.d/mysqld3006
basedir=/usr/local/mysql3306 datadir=/usr/local/mysql3306/data conf=/usr/local/mysql3306/etc/my.cnf $bindir/mysqld_safe --defaults-file=$conf --datadir=$datadir --pid-file=$server_pid_file $other_args >/dev/null 2>&1 & --------------------------------------------
Configuration de la base de données deux :
# vi /etc/init.d/mysqld3007
basedir=/usr/local/mysql3307 datadir=/usr/local/mysql3307/data conf=/usr/local/mysql3307/etc/my.cnf $bindir/mysqld_safe --defaults-file=$conf --datadir=$datadir --pid-file=$server_pid_file $other_args >/dev/null 2>&1 & --------------------------------------------
9. Configurations liées à l'élément de démarrage du système
# chkconfig --add mysqld3306 #添加开机启动服务 # chkconfig --level 35 mysqld3306 on #设置mysql启动
# chkconfig --add mysqld3307 # chkconfig --level 35 mysqld3307 on
# service mysqld3306 start
# service mysqld3307 start
# echo "PATH=$PATH:/usr/local/mysql3306/bin;export PATH" >> /etc/profile # source /etc/profile
# /usr/local/mysql3306/bin/mysqladmin -u root password 123456 #设置超级管理员密码 # /usr/local/mysql3306/bin/mysql -P3306 -S/tmp/mysql3306.sock -uroot -p123456 #连接数据库
# /usr/local/mysql3307/bin/mysqladmin -u root password 123456 #设置超级管理员密码 # /usr/local/mysql3307/bin/mysql -P3307 -S/tmp/mysql3307.sock -uroot -p123456 #连接数据库
# mysql -P3307 -S/tmp/mysql3307.sock -uroot -p123456
#lsof -i:3306 #lsof -i:3307
IV , Problème
scripts/mysql_install_db --user=mysql --datadir=/usr/local/mysql3306/data
2. cp : impossible de stat `/usr/local/mysql3307/support-files/mysql.server' : aucun fichier ou répertoire de ce type
-bash: ./scripts/mysql_install_db: No such file or directory
cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld3307
cp: cannot stat `/usr/local/mysql3307/support-files/mysql.server': No such file or directory
Lors du démarrage de la base de données, exécutez la commande
service mysqld3307 start
env: /etc/init.d/mysqld3307: Permission denied
Ce qui précède est le contenu détaillé de. pour plus d'informations, suivez d'autres articles connexes sur le site Web de PHP en chinois!
des centaines
mysql modifier le nom de la table de données
MySQL crée une procédure stockée
La différence entre MongoDB et MySQL
Comment vérifier si le mot de passe MySQL est oublié
mysql créer une base de données
niveau d'isolement des transactions par défaut de MySQL
La différence entre sqlserver et mysql
![[Web front-end] Démarrage rapide de Node.js](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
