Ubuntu MySQL 5.x

So here is a great guide to installing MySQL on Ubuntu 8.10 Server and creating a user account to access the database.

Installing the software if not already installed.
apt-get install mysql
apt-get install libmysqlclient15-dev

Make sure that set the "bind-address" in /etc/mysql/my.cnf is set to the ip address of the computer.
Once installed you will need to create the accounts in order to log in from remote.
INSERT INTO user SET Host='localhost', User='admin', Password=password('SOME_PASSWORD');
INSERT INTO user SET Host='%', User='admin', Password=password('SOME_PASSWORD');

Once inserted into the database simply upgrade the permissions.
GRANT ALL PRIVILEGES ON *.* TO 'admin'@'localhost' IDENTIFIED BY 'SOME_PASSWORD' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO 'admin'@'%' IDENTIFIED BY 'SOME_PASSWORD' WITH GRANT OPTION;
To be honest I recommend you then restart the mysql service.
/etc/init.d/mysql restart

Now you should be good to go with creating the new databases.

Comments

Popular posts from this blog

Console over SSH (ONTAP)

Cacti Monitor Server Step by Step Ubuntu

Brocade Zone Setup