0

Hello, I am currently renting a VPS for the purpose of host a magento store. The VPS is running Centos5 with DirectAdmin.

I have read a bit about how to optimize magento and one suggestion I have seen is to edit the MySQL configuration file. However, I cannot find this file anywhere from within DirectAdmin. Also, I cannot connect to the VPS via SSH. My host has a root access via their website but it won't let me enter my root password.

Any and all help would be greatly appreciated.

1

2 Answers 2

1

Try downloading and installing Putty assuming you're using a Windows PC - you should be able to use this to connect directly to the command line of your server as the root user. If this doesn't work then you should contact your VPS hosting provider and let them know. Its possible that they may not have configured your account properly.

Once you're logged in then you can find all files on your VPS called my.cnf using the following command:

find / -name my.cnf

Normally on a centos machine this file is located somewhere in /etc

find /etc -name my.cnf

will search just the /etc folder and be much quicker

3
  • Ok i tried putty just input the hostname and port 22 plus SSH connection type.... console appears asking for login as. I chose admin then it asks for password but as with their website based console, it won't let me type a password... the cursor won't move.
    – user60868
    Jan 30, 2011 at 1:06
  • The cursor doesn't move when you are entering a password. This is to prevent exposing information about your password (such as its length).
    – larsks
    Jan 30, 2011 at 1:06
  • Agreed. Also, you should add this as a comment to Xoundboy's post, not as an answer.
    – Andrew M.
    Jan 30, 2011 at 1:06
1

The standard location is:

/etc/my.cnf

Also, if you are on Windows, download Putty. Then, run Putty and enter your server's IP address. It will ask you for a user name. Type "root" and press enter. Then, It will ask you for a password. Type it in and press enter. To edit the MySQL configuration file type this command:

vi /etc/my.cnf

If you do not know how to use vi. There is an excellent tutorial available here: http://www.washington.edu/computing/unix/vi.html

1
  • I just realized that this question is almost a year old.
    – Richardp
    Sep 6, 2011 at 22:39