mysql server

Q. How do I display a list of all databases under MySQL Server?

{ 3 comments }

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

{ 0 comments }

Q. I’m using FreeBSD server version 6.2. How do I start / stop MySQL server from a shell prompt over ssh session? A. First login as the root user. Next make sure MySQL service is enabled. Just open /etc/rc.conf file using vi text editor: # vi /etc/rc.conf Append / modify following line to start MySQL [...]

{ 8 comments }

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. [...]

{ 3 comments }

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 [...]

{ 3 comments }

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 [...]

{ 10 comments }

How do I change MySQL root password under Linux, FreeBSD, OpenBSD and UNIX like operating system over ssh / telnet session?

{ 120 comments }