Ubuntu 14 installation MySQL Guide
Install MySQL
sudo apt-get install Mysql-server
This should be very simple, and I think everyone in the installation is not too much problem, so it is not much to say, the following we talk about configuration.
Configure MySQL
Note that the MySQL default in Ubuntu is only allowed for local access, if you want to be able to access other machines, then you need to change the/ETC/MYSQL/MY.CNF configuration file! Below we step by step:
The root user does not have a password after the default MySQL installation, so first use the root user to enter:
$mysql-U Root
Here the reason for using-u root is because I am now a general user (Firehare), if you do not add-u root, MySQL will assume that it is firehare log in. Note that I do not have access to root user mode here because it is not necessary. In general, the database in MySQL operation, there is no need to enter the root user mode, only in the setting of this possibility.
After entering MySQL, the most important thing is to set up the root user password in MySQL, otherwise, the MySQL service is not safe to say.
Mysql> GRANT All privileges on * * to [e-mail protected] identified by "123456";
Note that I use 123456 as the root user's password, but the password is not secure, please use a combination of uppercase and lowercase letters and numbers, and not less than 8 bits.
In this case, you set up the root user password in MySQL, and then use the root user to build the database you need. Here I take xoops as an example:
Mysql>create DATABASE Xoops;
Mysql>grant all privileges in xoops.* to [e-mail protected] identified by "654321";
This establishes a xoops_roots user, which has full access to the database Xoops. After the use of Xoops_root to the Xoops database management, and no need to use the root user, and the user's permissions are only limited to the Xoops database.
If you want to do remote access or control, then you need to do two things:
One
Mysql>grant all privileges in xoops.* to [e-mail protected] "%" identified by "654321";
Allows xoops_root users to log in to MySQL from any machine.
Second:
$sudo gedit/etc/mysql/my.cnf
In the old version
>skip-networking = # skip-networking
In the new version
>bind-address=127.0.0.1 = bind-address= The IP of your machine
This allows other machines to access MySQL.
Ubuntu 14 Installation MySQL Guide
