VPS Linux


Add a second instance of MySQL on existing MySQL Server

//////my sql installation mysql_install_db –user=mysql –basedir=/usr –datadir=/var/lib/mysql2 –defaults-file=/etc/mysql/my_server2.cnf mysqld_safe –defaults-file=/etc/mysql/my_server2.cnf –user=mysql & netstat -tanp |grep 3307 mysql -u root -p -h 127.0.0.1 -P 3307 //allow remote access GRANT ALL PRIVILEGES ON *.* TO ‘root’@’%’ IDENTIFIED BY ‘password’ WITH GRANT OPTION; FLUSH PRIVILEGES; //update password update user set password=PASSWORD(“mynewpassword”) where User=’root’; […]