This section helps first timers to quickly setup MySQL environment so Dbvisit Replicate can be configured after that to establish proof of concept in testing environment.
Please also check the Dbvisit blog site for relevant articles, tips and tricks at:
http://blog.dbvisit.com/category/mysql/
If MySQL is not installed then it can be installed with the following command. This installs the MySQL database and the MySQL client.
...
| Note | ||
|---|---|---|
The MySQL database software only needs to be installed on the target server. However to establish a mysql connect from the source server the mysql client software is needed. On the source server only install:
|
You can start the MySQL database using following command:
| No Format | ||
|---|---|---|
| ||
/etc/init.d/mysqld start |
Use mysql command to connect to The MySQL server. This program is started by executing the command mysql at the shell prompt. You can connect using following command. You can find more information about MySQL and configuring authentication here
| No Format | ||
|---|---|---|
| ||
mysql -u root |
...
| Note |
|---|
Ensure you understand MySQL privileges fully on your production server before running this command as it may open expose the database too much. Reduce the privileges as required. |
...
| Note |
|---|
Ensure you understand MySQL privileges fully on your production server before running this command as it may open expose the database too much. Reduce the privileges as required. |