Install MySql in Ubuntu and connect to the Internet, while tumysql is on the Internet.

Source: Internet
Author: User

Install MySql in Ubuntu and connect to the Internet, while tumysql is on the Internet.

Pure beginner tutorial.


1. Install mysql

apt-get install mysql-server mysql-client libmysqlclient15-dev 


During the installation process, you will be prompted to set a password for the root account of the database. Enter the two passwords.

2. Enter

mysql  mysql -uroot -p 


3. Reset the mysql user root password.

GRANT ALL PRIVILEGES ON *.* TO root@localhost IDENTIFIED BY "123456";


4. Create a new database proxy

create database proxy;


5. create user test with full operation permissions on the proxy Database

grant all privileges on proxy.* to test@localhost identified by "testpwd";


6. Allow the test user to log on to MySQL from any machine

grant all privileges on proxy.* to test@"%" identified by "testpwd"; 


7. log out of mysql

exit


8. After mysql is installed, the default listening address is 127.0.0.1 and port is 3306. You can run the following command to view the listening address and port:

netstat -ntulp



9. If you are listening for 127.0.0.1, the database cannot be connected from the Internet. In this case, you can modify the listening address to 0.0.0.0:

sudo vim /etc/mysql/my.cnf


Find bind-address = 127.0.0.1, change 127.0.0.1 to 0.0.0.0, save and exit

10. Restart mysql to make the configuration take effect.

service mysql restart


Now, you can remotely connect to the mysql database using MySql_Front or phpmyadmin. However, you can only remotely log on to the test account you just authorized. By default, the root account does not allow remote database logon. You can use either of the following methods to allow the root account to remotely log on to the database:

(1). Change the table method.

It may be that your account is not allowed to log on remotely, but only on localhost. At this time, you only need to log in to mysql on the computer of localhost, and change the "host" entry in the "user" table in the "mysql" database to "%" from "localhost"

<pre name="code" class="sql">mysql -u root -pmysql>use mysql;mysql>update user set host = '%' where user = 'root';mysql>select host, user from user;

(2). Authorization method.

For example, if you want myuser to use mypassword to connect to the mysql server from any host:

GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'%' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;

If you want to allow myuser to connect to the mysql server from a host whose ip address is 192.168.1.3, and use mypassword as the password

GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'192.168.1.3' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;

If you want to prevent the root account from logging on to the mysql database remotely due to security concerns:

delete from user where user = 'root' and host = '%';select host, user from user;flush privileges;



 
 


The best way to connect to Mysql from ubuntu to the database is illustrated

Isn't mysql-uroot-p123456 directly from the command line?
Root is username p is password ~~
 
How to install mysql server in ubuntu 1010

Install MySQL

Sudo apt-get install mysql-server

This should be very simple, and I don't think there is much problem with the installation, so I will not talk about it much. Let's talk about the configuration below.

Configure MySQL

Note: In Ubuntu, MySQL only allows local access by default. If you want access from other machines, you need to change the/etc/mysql/my. cnf configuration file! Next we will step by step:

After the default MySQL installation, the root user does not have a password. Therefore, use the root user to enter:

$ Mysql-u root

-U root is used here because I am a general user (firehare). If-u root is not added, mysql will assume that it is a firehare logon. Note: I have not entered the root user mode here because it is unnecessary. In general, it is not necessary to enter the root user mode to operate the database in mysql. This is only possible when the database is set.

After entering mysql, the most important thing is to set the root user password in Mysql. Otherwise, the Mysql service is no longer secure.

Mysql> grant all privileges on *. * TO root @ localhost identified by "123456 ";

Note: I use 123456 as the root user password, but this password is not safe. Please use a password with a mix of uppercase and lowercase letters and numbers, and at least 8 characters.

In this case, the root user password in MySQL is set up, and then the database you need is created with the root user. Here we take xoops as an example:

Mysql> create database xoops;

Mysql> grant all privileges on xoops. * TO xoops_root @ localhost identified by "654321 ";

In this way, a xoops_roots user is created, which has all permissions on the database xoops. In the future, we will use xoops_root to manage the xoops database, instead of using the root user. This user's permissions will only be limited to the xoops database.

If you want to implement remote access or control, you have to do two things:

1:

Mysql> grant all privileges on xoops. * TO xoops_root @ "%" identified by "654321 ";

Allows the xoops_root user to log on to MySQL from any machine.

Second:

$ Sudo gedit/etc/mysql/my. cnf

Earlier versions

> Skip-networking => # skip-networking

New Version

> Bind-address = 127.0.0.1 => bind-address = IP address of your machine

This allows other machines to access MySQL.
Reference: ubuntu Chinese official website forum... remaining full text>

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.