Posted by cikul | Posted in Linux, SQL, Tips | Posted on 18-10-2015-05-2008
This tutorial explains how to change or reset your MySQL root password under Unix-Like Operating Systems (Linux, FreeBSD, OpenBSD, etc) over SSH. MySQL root account should be managed carefully.
As a system administrator, we must ensure that the password is safe and prevent from unauthorized access.
There are some method to change mysql password :
Type 1 : use mysqladmin
However, if you want to change mysql root/user password, mysql had tool to simplify the process using mysqladmin command, the syntax is :
$ mysqladmin -u root -p'oldpassword' password newpass
$ mysqladmin -u dbuser -p'oldpassword' password 'itsnewpassword';
Read the rest of this entry »
Share and Enjoy
Posted by cikul | Posted in Internet, Linux, web | Posted on 20-04-2009-05-2008
For the web server that using mysql as a database engine. Sometimes the process in mysql need a large resource, especially if server has a high traffic. According to my experience, to the high traffic server, the MySQL process itself can spend more than 30% of server resources. So, I will give you tips for optimizing mysql on the server that has high traffic.
Mysql configuration located in the my.cnf file, usually this file is in the /etc directory, but can also in other folders. For more safe, you can search my.cnf file to make sure the location of the file. Read the rest of this entry »
Incoming search terms:optimize mysql server
| your applications are not closing mysql connections properly
| how to optimize mysql server
| optimize mysql
| mail madeinkabupatenmalang com
Share and Enjoy