grant select on database

MySQL Command overview-command details 1. Connect to MySQL. Format: mysql-H host address-u user name-P User Password 1. Example 1: connect to MySQL on the local machine. First, open the DOS window, enter the directory mysqlbin, then type the command

Install RMP-IVH MySQL-server-4.1.22-0.glibc23.i386.rpm -- nodeps RMP-IVH MySQL-client-4.1.22-0.glibc23.i386.rpm -- nodeps Check whetherInstallSuccessful Netstat-atln If the port 3306 is opened, the installation is successful.Login MySQL [-u

I. Introduction I have been using Linux for a long time. I have never studied hard tasks and system learning. Recently, I have to use MySQL in Linux for my work. I thought that Windows EnabledUse SQLServer experience, I think it should be easy

1) connect to MySQL: Format: mysql-H host address-u user name-P User Password 1. Example 1: connect to MySQL on the local machine First, open the DOS window, enter the bin directory under the MySQL installation directory, for example, D: \

1> extract the compressed file mysql-noinstall-5.1.6-alpha-win32.zip to a directory, set mysql_home in the environment variable, and add % mysql_home % \ bin to path. 2> Create my. ini configuration file, content: [mysqld] # Set basedir to MySQL

1. Connect to the MySQL database1. Open cmd to enter the DOS window.2. Switch to the directory: D:/mysql5.0/mysql-5.0.51b-win32/bin (I .e., the bin directory under the MySQL installation directory, which contains a lot of EXE execution files)3.

I. Introduction I have been using Linux for a long time. I have never studied hard tasks and system learning. Recently, I have to use MySQL in Linux for my work. I thought that I had experience using SQL Server in windows and thought it would be

1. Install mysql in windows 1. Set the system environment variable to create a new system variable named MYSQL_HOME in the system environment variable. The value of the variable "MYSQL_HOME" is: Add a Path to the mysql installation Path in the Path:

[Mysql] Common commands-user operations (create, authorize, modify, delete) and mysql user operations Each user in Mysql corresponds to different user addresses and permissions. There are three ways to create a Mysql user: 1. create user 2. grant 3.

Format: grant select on database. * to username @ login host identified by "password" Example 1: Add a user user_britepic whose password is bkjia so that he can log on to any host and have the permission to query, insert, modify, and delete all

I. IntroductionI have been using Linux for a long time. I have never studied hard tasks and system learning. Recently, I have to use MySQL in Linux for my work. I thought that I had experience using SQL Server in Windows and thought it would be easy

This article summarizes many common MySQL commands on the network and describes the process in detail. 1. Connect to MySQL Format: mysql-h host address-u user name-p User Password 1. Example 1: connect to MYSQL on the local machine. First, open the

Many friends have installed MySQL but do not know how to use it. In this article, we will learn some common MySQL commands from the aspects of connecting to MySQL, changing the password, and adding users. 1. Connect to MySQL. Format: mysql-h host

Mysql installation directoryDatabase directory/Var/lib/mysql/Configuration File/Usr/share/mysql (mysql. server command and configuration file)Related commands/Usr/bin (commands such as mysqladmin mysqldump)Start script/Etc/init. d/mysql (directory

How to download and install the MySQL database: : Http://dev.mysql.com/downloads/. download the package and install it in double steps. ========================================================== ===== How to configure the MySQL database:

I. Introduction I have been using Linux for a long time. I have never studied Linux since I have no hard tasks or systems. Recently, I have to use MySQL in Linux for my work. I thought that I had experience using SQL Server in windows and thought it

Put mysql.exe in the binary directory under mysqldirectory under c: \ windows. You can run the following command: Connection: mysql-H host address-u user name-P User Password (Note: U and root do not need to add spaces, the same is true for

MySQL error number 2003 Can't connect to MySQL Server XXX. XXX (10061) MySQL is installed by default in Ubuntu 9.04, which can only be accessed locally by default. Google: Use Log on to the MySQL server and run the command in the MySQL

Solaris10LowerMySQLInstallation and maintenance MySQL is a very popular database system in open-source software. However, it cannot be started successfully when it is installed on Solaris according to the installation manual provided on the MySQL

MySQL Command collection [Note: You can use mysql> select version (); in MySQL to view the database version] 1. Connect to MySQL. Format: mysql-H host address-u user name-P User Password 1. Connect to MySQL on the local machine. First, open the DOS