Configuring MySql 5.4 on RHL5.

0 votes
No avatar asked by (120 points) about MySQL Community Server
edited by

I want to install and configure MySql version 5.4 on RHL5. Can you help?

1 Answer

0 votes
No avatar answered by (193k points)

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.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
Anti-spam verification:
To avoid this verification in future, please log in or register
...