Mysql Database Server Installation and Configuration in Ubuntu

MySQL is a widely used and fast SQL database server. It is a client/server implementation that consists of a server daemon (mysqld) and many different client programs/libraries.



Installing Mysql database in Ubuntu


#apt-get install mysql-server mysql-client libmysqlclient12-dev


MySQL initially only allows connections from the localhost (127.0.0.1). We’ll need to remove that restriction if you wish to make it accessible to everyone on the internet. Open the file /etc/mysql/my.cnf

#vi /etc/mysql/my.cnf
Find the line bind-address = 127.0.0.1 and comment it out
…
#bind-address = 127.0.0.1
…

You can check your configuration using the following command

#netstat -tap


Output Looks like below


tcp 0 0 *:mysql *:* LISTEN 4997/mysqld



MySQL comes with no root password as default. This is a huge security risk. You’ll need to set one. So that the local computer gets root access as well, you’ll need to set a password for that too. The local-machine-name is the name of the computer you’re working on. For more information see here

#mysqladmin -u root password your-new-password


#mysqladmin -h root@local-machine-name -u root -p password your-new-password


#/etc/init.d/mysql restart

Categories: mysql