Bobylog Blog 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'; FLUSH PRIVILEGES; //my sql armour [...]