How to change your mysql configuration

loading........
here is the simple steps to change your mysql configuration
Thats all.
connection closed.
here is the simple steps to change your mysql configuration
- Stop completelly your mysql instance:
- Code: Select all
service mysqld stop
- Create a temporary directory:
- Code: Select all
mkdir /var/lib/mysql/old/
- Move the next files to temporary directory:
- Code: Select all
mv /etc/my.cnf /var/lib/mysql/old/old.cnf
- Code: Select all
mv /var/lib/mysql/ib_logfile* /var/lib/mysql/old/
- Upload your new Configuration:
- Code: Select all
cp my.cnf /etc/my.cnf
- Start mysql:
- Code: Select all
service mysqld start
Thats all.
connection closed.