MySQL quick installation and client Access authorization in Linux

MySQL quick installation and client Access authorization in Linux: yuminstallmysql-server install mysql server etcinit. dmysqldstart start mysql

MySQL quick installation and client Access authorization in Linux: yum install mysql-server // install mysql server/etc/init. d/mysqld start // start mysql

Homepage → Database Technology

Background:

Read News

MySQL quick installation and client Access authorization in Linux

[Date: 2012-03-01] Source: Linux Author: yangbaba2000 [Font:]

Quick MySQL installation and client Access authorization in Linux:

Yum install mysql-server // install mysql server

/Etc/init. d/mysqld start // start the mysql server

--------------------------------- Client Access Authorization ----------------------------------------------------

A user table in MYSQL stores the database user information. One column is host, which defines the Client ip address that can access the server.

To allow all clients to access the database, perform the following:

Note: All clients can use root to access the database and retain the initial password.

Grant all privileges on *. * TO 'root' @ '%' with grant option;

Note: All clients can access the database using the root account and use the admin account as the password.

Grant all privileges on *. * TO 'root' @ '%' identified by 'admin' with grant option;

0

Install Mysql in CentOS 64bit -- Solve the Problem of Can't connect to local MySQL server through socket"

Import and export data using Hive

MySQL database tutorial

Image Information

View All comments in this article (0)

Comments

Latest Information

Popular this week

Introduction to Linux community-advertisement service-website map-help Info-contact us
The articles published on this site (LinuxIDC) do not mean that they agree with the statement or description. They only provide more information and do not constitute any suggestions.


Copyright©2006-2011 Linux community All rights reserved Zhejiang ICP backup No. 06018118