Initial Configuration after MySQL is installed in ubuntu

1. It should be easy to install MySQL, and I don't think there is much problem in the installation, so I will not talk about it much. Next let's talk about the configuration.

2. Configure MySQL. Note that MySQL in Ubuntu only allows local access by default. If you want access from other machines, change/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 here uses-u root because I am a general user (firehare). If-u root is not added, mysql will assume that it is a firehare login.

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:

1 2 3 Next Page

[Content navigation]
Page 1st: Initial Configuration after MySQL is installed in ubuntu	Page 2nd: Initial Configuration after MySQL is installed in ubuntu
Page 3rd: Initial Configuration after MySQL is installed in ubuntu