How to Install Multiple MySQL Servers on Windows Machines - MySQL DBA Tutorial
19.5 هزار بار بازدید -
6 سال پیش
-
How to Install Multiple MySQL
How to Install Multiple MySQL Servers on Windows Machines - MySQL DBA Tutorial demo explains the limitations that we can't install the MySQL multiple Servers on same machine by using MySQL Installer. Below are the steps you have to perform to install another MySQL server on windows machine on which you already have installed MySQL.
1) Create a new folder on C drive, let's say MYSQLDEV
2) Copy all the folders from c:\programfile\MySQL to MYSQLDEV
3) Search for my.ini in %PROGRAMDATA%\MySQL and copy to MYSQLDEV and also copy Data directory
4) Change the port for [client] and [mysqlid] in mysqldev.ini file
5) change the basedir and datadir location to new location
6) execute mysqld --install MYSQLDEV --defaults-file="c:/MYSQLDEV/mysqldev.ini"
7) Start the services net start MYSQLDEV
8) Connect to MySQL mysql -u root --Port=3307
9) Run show variables where variable_name in ('hostname','port');
10) Change the root password if you need to for newly installed MySQL service
ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass';
To follow step by step tutorial for MySQL DBA for beginner to Advance
http://www.techbrothersit.com/2018/11...
MySQL Workbench Tutorial
MySQL DBA Certification Training
MySQL DBA Tutorial Step by Step
MySQL DBA Training online free
MySQL Real Time DBA Tutorial
MySQL Administration Course step by Step
MySQL Tools for Development and Admin
1) Create a new folder on C drive, let's say MYSQLDEV
2) Copy all the folders from c:\programfile\MySQL to MYSQLDEV
3) Search for my.ini in %PROGRAMDATA%\MySQL and copy to MYSQLDEV and also copy Data directory
4) Change the port for [client] and [mysqlid] in mysqldev.ini file
5) change the basedir and datadir location to new location
6) execute mysqld --install MYSQLDEV --defaults-file="c:/MYSQLDEV/mysqldev.ini"
7) Start the services net start MYSQLDEV
8) Connect to MySQL mysql -u root --Port=3307
9) Run show variables where variable_name in ('hostname','port');
10) Change the root password if you need to for newly installed MySQL service
ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass';
To follow step by step tutorial for MySQL DBA for beginner to Advance
http://www.techbrothersit.com/2018/11...
MySQL Workbench Tutorial
MySQL DBA Certification Training
MySQL DBA Tutorial Step by Step
MySQL DBA Training online free
MySQL Real Time DBA Tutorial
MySQL Administration Course step by Step
MySQL Tools for Development and Admin
6 سال پیش
در تاریخ 1397/08/24 منتشر شده
است.
19,568
بـار بازدید شده