≡ Menu

mysql server

I'm setting up WordPress based blog system under Debian or Ubuntu Linux. I am getting an error which read as follows:

Tutorial details
DifficultyEasy (rss)
Root privilegesYes
Estimated completion timeN/A

Your PHP installation appears to be missing the MySQL extension which is required by WordPress

How do I fix this problem under Debian or Ubuntu Linux?
[click to continue…]

MySQL List Databases

Q. How do I display a list of all databases under MySQL Server?
[click to continue…]

Q. How do I start and stop mysql server under Debian / Ubuntu Linux system?

[click to continue…]

FreeBSD Start / Stop / Restart MySQL Server

I am a new FreeBSD version 6.x/7.x/8.x/9.x/10.x server user. How do I start / stop or restart MySQL server from a shell prompt over ssh session?
[click to continue…]

Change MySQL root password

Q. How do I change MySQL server root password under Linux / UNIX operating system at shell prompt?

A. You need to mysqladmin command which is a client for performing administrative operations. You can use it to check the server’s configuration and current status, to create and drop databases, change mysql root password and more.

How do I change mysql root password?

If you are setting a root password first time, use any one of the following command syntax:
mysqladmin password "NEW-PASSWORD"
mysqladmin -u root password "NEW-PASSWORD"
mysqladmin -u root -h localhost password "NEW-PASSWORD"

To set password to d3s9cXq, enter:
# mysqladmin -u root password "d3s9cXq"

Please note that if the NEW-PASSWORD value contains spaces or other characters that are special to your command interpreter, you need to enclose it within quotes. Thus, the next time you invoke mysqladmin (or any other client program such as mysql) using the same account, you will need to specify the new password. So to login as root, enter the command:
# mysql -u root -p
# mysql -h localhost -u root -p


  • -u root: Specify username
  • -p : Prompt for password

If you would like to change current password d3s9cXq to OlzzYs$qz, enter the following command:
# mysqladmin -u root -p password "OlzzYs$qz"

Enter password: <enter old password>

Q. How do I backup files and database for the Red Hat Enterprise Linux / CentOS Linux? Currently I’ve MySQL server running on CentOS 5 and Web server and file server using RHEL 5. How do I backup all these servers?

A. Regular backup is an essential for Linux system. You can take backup on
=> Tape
=> NAS Server
=> DVD
=> Network server etc

Implementing a backup policy that includes rotating backup media and keeping copies of backup media offsite is the most reliable way of minimizing damage. See following resources on our site for more information including commands and shell scripts:

  1. Perform backups for the Linux operating system
  2. How to backup MySQL databases, web server files to a FTP server automatically
  3. Howto Backup PostgreSQL Databases
  4. All backup shell scripts

PHP not connecting to a MySQL database server

Q. I have Apache Web server and MySQL configured. Everything works fine except I am not able to connect to a MySQL database server (I am able to connect mysql server with mysql client). So how do I configure or connect PHP scripts?

A. You need to install MySQL module for php4 or php5. Without php-mysql shared object or module, php scripts won't able to connect to MySQL database server.

Debian / Ubuntu Linux User

To install type the following command:
# apt-get install php4-mysql
if you are using PHP5, enter:
# apt-get install php5-mysql

RHEL <= 4 user

If you are using Red Hat Linux:
# up2date php-mysql

If you are using Fedora / CentOS / RHEL 5 Linux:
# yum install php-mysql
Restart apache to take effect. Now you will be able to connect MySQL via PHP scripts.
# service httpd restart