Upgrading a database server(and especially MySQL) requires more than a few simple launch-install steps. You have to make sure that the old database is compatible with the new structure and functions provided by the new version. There are also changes that have been implemented in new versions which might not be compatible with what you have. Kindly study the documentation page that I linked below to take all the necessary steps to prepare for a database update.
Note: As a friendly reminder, follow this saying "if it isn't broken, don't fix it". Of course there are security exceptions, but if the MySQL is working fine and all the updates are working fine as well, don't migrate to a much higher version unless you are told so.
I recommend checking the MySQl Upgrade documentation because the procedure is different for the available operating systems.
I am trying to make multi-source MySQL replication. But I need to replicate only one database to one slave instance and other database to other slave instance. If I use replicate-do-db in master it replicates two databases to both slaves. Please suggest me any other way to replicate different databases.
S
Answer by
Sean Hill
The official website of MySQL provides an in-depth guide and tutorials on how to establish MySQL replication. Access the page listed below to learn how to do it properly without errors. This is the best way because you have the information directly from the developers and you can be sure that it will work under the given situation. Follow the instructions on the page and adjust the data according to your databases.
I installed MySQL, but I no longer remember my password. Yesterday, I tried to open it but the password was totally wrong. Can you help me to renew my password? I need to use it for my final year project.
M
Answer by
MasterBETA
The default password is blank with "su" as username. You can actually find the config file on the hard drive located in the server folders. You can edit the text via NotePad.
I want to install and configure MySql version 5.4 on RHL5. Can you help?
P
Answer by
Pete Clapp
You can install MySQL from the RHN or CentOS repo. In order to install the utility, open the terminal and type the following command:
# yum install mysql-server mysql
After that, use the command below to open the MySQL Service:
# chkconfig mysqld on # /etc/init.d/mysqld start
If you want to set a password type # mysqladmin -u root password NEWPASSWORD and check the connectivity using $ mysql -u root -p command. In order to begin the configuration process, you will need to type # vi /etc/my.cnf.
After that, configure the caches and other limits using the following codes:
The above limits are sample values that can be adjusted as you want. You can find additional guides, instructions and tutorials that will help you install and configure MySql 5.4 on RHL5, using Google search engine.
Regarding the question: To install MySQL Community Server for Windows, you can follow these steps:
After installation, you should have MySQL Community Server installed on your Windows machine.
How to install update 5.1-5.7 MySQL?
Upgrading a database server(and especially MySQL) requires more than a few simple launch-install steps. You have to make sure that the old database is compatible with the new structure and functions provided by the new version. There are also changes that have been implemented in new versions which might not be compatible with what you have. Kindly study the documentation page that I linked below to take all the necessary steps to prepare for a database update.
Note: As a friendly reminder, follow this saying "if it isn't broken, don't fix it". Of course there are security exceptions, but if the MySQL is working fine and all the updates are working fine as well, don't migrate to a much higher version unless you are told so.
I recommend checking the MySQl Upgrade documentation because the procedure is different for the available operating systems.
I am trying to make multi-source MySQL replication. But I need to replicate only one database to one slave instance and other database to other slave instance. If I use replicate-do-db in master it replicates two databases to both slaves. Please suggest me any other way to replicate different databases.
The official website of MySQL provides an in-depth guide and tutorials on how to establish MySQL replication. Access the page listed below to learn how to do it properly without errors. This is the best way because you have the information directly from the developers and you can be sure that it will work under the given situation. Follow the instructions on the page and adjust the data according to your databases.
Tutorials page: https://dev.mysql.com/doc/refman/5.7/en/replication-multi-source-tutorials.html
The sql command prompt is one of the ways to use it. You can also log in via your local host.
I installed MySQL, but I no longer remember my password. Yesterday, I tried to open it but the password was totally wrong. Can you help me to renew my password? I need to use it for my final year project.
The default password is blank with "su" as username. You can actually find the config file on the hard drive located in the server folders. You can edit the text via NotePad.
I want to install and configure MySql version 5.4 on RHL5. Can you help?
You can install MySQL from the RHN or CentOS repo. In order to install the utility, open the terminal and type the following command:
# yum install mysql-server mysql
After that, use the command below to open the MySQL Service:
# chkconfig mysqld on
# /etc/init.d/mysqld start
If you want to set a password type # mysqladmin -u root password NEWPASSWORD and check the connectivity using $ mysql -u root -p command. In order to begin the configuration process, you will need to type # vi /etc/my.cnf.
After that, configure the caches and other limits using the following codes:
query_cache_type = 1
query_cache_limit = 1M
query_cache_size = 32M
tmp_table_size = 32M
max_heap_table_size = 32M
max_connections = 500
thread_cache_size = 50
open_files_limit = 65535
table_definition_cache = 4096
table_open_cache = 512
The above limits are sample values that can be adjusted as you want. You can find additional guides, instructions and tutorials that will help you install and configure MySql 5.4 on RHL5, using Google search engine.