MySQL Database Server Installation and Configuration in Debian
Posted by Admin on April 14th, 2007
If you're new here, you may want to subscribe to my RSS feed. Thanks for visiting!
Install Mysql database server in Debian
#apt-get install mysql-server mysql-client libmysqlclient15-dev
This will install all the required packages for mysql database server.
Now you need to configure MySQL to listen on all interfaces, not just localhost for this you need to edit /etc/mysql/my.cnf and comment out the line bind-address = 127.0.0.1 save and exit the file.
#vi /etc/mysql/my.cnf
#bind-address = 127.0.0.1
Now you need to restart MySQL server using the following command
#/etc/init.d/mysql restart
Testing Mysql Networking
Now you need to check that networking is enabled or not using the following commnd.
#netstat -tap
In the output you should see similar to the following line
tcp 0 0 *:mysql *:* LISTEN 3281/mysqld
Setting Mysql Root password
Irf you want to set Mysql Root password use the following command
#mysqladmin -u root password mysqlrootpassword
In the above command you need to replace mysqlrootpassword with your secret password
Once you set the root password you can test this password using the following command
#mysqladmin -h serverip -u root password mysqlrootpassword
Once you loggedin in to the mysql database you should see the following mysql prompt
mysql>
If you want to install web interface or GUI tool for Mysql check here
June 17th, 2009 at 2:25 pm
how to remove mysql-server mysql-client libmysqlclient15-dev Says: Your comment is awaiting moderation.
June 17th, 2009 at 2:25 pm
how can you remove all I did above….I mean
mysql-server mysql-client libmysqlclient15-dev???
I tried apt-get remove mysql-server mysql-client libmysqlclient15-dev
but apparently it doesnt do it completely, anyone help please?
July 15th, 2009 at 9:10 pm
You could try
apt-get purge
or
apt-get autoclean
that should clean it all up for ya after you
apt-get remove mysql-server mysql-client libmysqlclient15-dev