How to enable MySQL remote access on Ubuntu Server 12.04

mysql
mysql

By default MySQL on Ubuntu Server 12.04 can only be accessed from localhost (127.0.0.1).

 If we need to access it from another computer on the network, we must do the following step
 Edit MySQL Configuration
 $ sudo vim /etc/mysql/my.cnf
#comment out this line (add # in front of the line)
Advertisements

Install MySQL Server 5.5 On Ubuntu 12.04 Precise Pangolin

mysql
mysql

To install MySQL Server 5.5 on Ubuntu 12.04 Precise Pangolin, make your way to a Terminal window or a command prompt, and type this command:

sudo apt-get install mysql-server-5.5

(As of this writing, MySQL Server version 5.5 is the latest version available in the repositories, though future versions of Ubuntu may receive the newer versions of MySQL.)

Enter your password to authenticate, and apt will download the MySQL files and install them for you. It’s a big set of files, so depending on the speed of your Internet connection, it might take a while to download. After the files are downloaded and are installing, the installer will ask you for a password for MySQL’s root user. Just like the root user in Linux, the root user in MySQL has absolute control over all databases, tables, permissions, and users. For obvious security reasons, you’ll want to create an extremely strong password (a mixture of uppercase, lowercase, numbers, and punctuation, the longer the better) for your MySQL root user. Continue reading “Install MySQL Server 5.5 On Ubuntu 12.04 Precise Pangolin”

Create a free website or blog at WordPress.com.

Up ↑