Hello, I am trying to edit my database parameters by editing my /etc/my.cnf file. However I am new to SSH and can't seem to get this working. The parameter I wants to change in /etc/my.cnf file are as follows max_connections 600 At the moment this value is 100. Please let me know if it is possible for you guys to do. I would really appreciate any help since I am new to this sort of editing. Please help. I can pay upto $20 dollars for this through paypal or alertpay. Thank you
Do you know if your server can handle 600 connections? That's a huge load on a server. Try: max_connections = 600 Then restart the mysqld service: # service mysqld restart If you get an error restarting it, check the mysql log. This is usually in /var/log/mysqld.log.
1. do you know how to make an SSH connection? If not, try googling putty.exe. 2. connect to your server and login 3. you might need to switch to "root", type su at the prompt and enter the password 4. then do 'locate my.cnf' to be sure the file is ad /etc 5. next you either 'cd etc' to /etc or do 'edit /etc/my.cnf' 6. change value, press 'ESC' for a menu, choose exit and save. 7. restart service as mentioned above.