Install and configure MySql in Linux SuSE

Install mysql in linux suse enterprise 10 and download the rpm package of the corresponding version from the mysql official website (now oracle ).

Http://www.mysql.com/downloads/mysql/#downloads

After the installation is complete, rpm-qa can see the installed mysql package. Here I have installed three packages: server, client, and devel.

1. The first thing after installation is to set a password for the root user,Usr/bin/mysqladmin-u root
Password 'new-password'You can;

2. Start mysql,/Etc/init. d/mysql stop | start | restart, And then you can test whether the root user can log on;

3. create a userTest_userIdentified'Passwd';

4. create a test database and directly createTest_dbJust fine;

5. add permissions to the new user.Test_userOnlyTest_dbPermission: grant
On test_db. *Test_user @ localhost;If the accessed machine is not a local machine, change the ip address;

Ps: Assign the root user all permissions on any machine:Grant all privileges on *. * to root @ "%" identified by 'Password' with grant option;Note thatFlush privilegesEffective in time;

You can useTest_userLog on and operateTest_dbNow;

In windows, you can download navicat ide. The graphic interface is very convenient.