Installing MySQL and configuring methods and common commands under Mac OS X

One. Install MySQL
1.mysqlhttp://dev.mysql.com/downloads/mysql/my machine is Mac 10.8, so use MYSQL-5.6.10-OSX10.7-X86_64.DMG to install the package;
2. The installation package is located in the hard drive image (. dmg) file, you must first double-click the icon in the search to install the file. You should install the image and display its contents.

Note: Be sure to close all running MySQL server instances using the MySQL Manager application (on Mac OS x server) or mysqladmin shutdown on the command line before continuing with the installation.
MySQL's Mac OS X pkg is installed to/usr/local/mysql-version, and a symbolic connection is also installed,/usr/local/mysql, pointing to the new location. If you have a/usr/local/mysql directory, rename it to/usr/local/mysql.bak first. When the installation is complete, the installer executes mysql_install_db to create the authorization table in the MySQL database.

The installation layout is similar to the tar file binary distribution; All MySQL binaries are in directory/usr/local/mysql/bin. By default, the MySQL socket file is created as/tmp/mysql.sock.

There are two ways to install MySQL under Mac, one for Compressed Package FormAnother type of . dmg File Installation package。

First, we introduce the installation method of the compressed package form:

$ sudo mv mysql-5.1.45-osx10.6-x86_64 /usr/local/mysql
$ cd /usr/local
$ sudo chown -R mysql:mysql mysql
$ cd mysql
$ sudo scripts/mysql_install_db --user=mysql
$ sudo chown -R root .
$ sudo chown -R mysql data

Then CD bin with
$ sudo ./mysql_secure_installation
To modify the root password, which is empty by default, is obviously less secure, and is then configured as appropriate, as the development environment is less restrictive.

$ sudo ./mysqld_safe
To start MySQL

$ sudo ./mysql -u root -p
Enter the root password you just set to log in to MySQL

$ sudo ./mysqld_safe stop
Stop MySQL

Installation package file Form installation method:

First, go to http://www.mysql.com/downloads/mysql download mysql-5.6.10-osx10.7-x86_64.dmg, and then double-click the file to install the two installation package files in the image.

A. MYSQL-5.6.10-OSX10.7-X86_64.DMG (MySQL Standard Edition installation)

B. mysqlstartupitem.pkg (MySQL startup project), you can automatically run the MySQL service when your computer starts the system, it installs in/library/startupitems/mysql/, if you do not want to run the MySQL service when the system starts, Please do not install. If you do not want to use it after installation, please delete the/library/startupitems/mysql/directory.

Start the MySQL service

1, if you have installed the MYSQLSTARTUPITEM.PKG, restart the computer.

2, if you have installed mysqlstartupitem.pkg or do not want to start the computer, run: application-utility-terminal, enter command in Terminal: sudo/library/startupitems/mysqlcom/mysqlcom start , then enter your system administrator password.

Turn off MySQL service

Enter the command in Terminal: sudo/library/startupitems/mysqlcom/mysqlcom stop, then enter your system administrator password.

You can also go to System Preferences-other-mysql, through which to start and stop the MySQL service.

Change the MySQL root account password

Terminal input command:/usr/local/mysql/bin/mysqladmin-u root password new password

You can change your password at any time by using this command.

Terminal login MySQL

Terminal Login MySQL

Method 1: Absolute path

Terminal input command:/usr/local/mysql/bin/mysql-u root-p

Tip: Enter your new password

Method 2: (recommended) relative path

Enter the command in the terminal:

To see if there is a path in the path:

Input command in terminal: Echo $PATH

No, go ahead.

Add Required path: path= "$PATH":/usr/local/mysql/bin

later

Input command in terminal: Mysql-u root-p can be

Two. Create User assignment permissions
Grant all privileges on * * to ' user ' @ ' localhost ' with GRANT option
Grant all privileges on * * to ' user ' @ ' localhost ' identified by ' 123456′;
Flush privileges;

1. Create a new user.

Log in to MySQL
@>mysql-u root-p
@> Password
Create user
mysql> INSERT INTO Mysql.user (Host,user,password) VALUES ("localhost", "Phplamp", Password ("1234"));
Refresh System Permissions Table
Mysql>flush privileges;
This creates a user named: Phplamp with a password of: 1234.

Then log in.

mysql>exit;
@>mysql-u phplamp-p
@> Enter password
Mysql> Login Successful

2. Authorize the user.

Log in to MySQL (with root privileges). I am logged in as root.
@>mysql-u root-p
@> Password
First create a database for the user (phplampdb)
Mysql>create database phplampdb;
Authorizes the Phplamp user to have all the permissions of the Phplamp database.
>grant all privileges in phplampdb.* to [e-mail protected] identified by ' 1234 ';
Refresh System Permissions Table
Mysql>flush privileges;
Mysql> Other operations


If you want to specify partial permissions to a user, you can write:
Mysql>grant select,update on phplampdb.* to [e-mail protected] identified by ' 1234 ';
Refreshes the System permissions table.
Mysql>flush privileges;


3. Delete the user.
@>mysql-u root-p
@> Password
Mysql>delete from user WHERE user= "phplamp" and host= "localhost";
Mysql>flush privileges;
Delete a user's database
Mysql>drop database phplampdb;

4. Modify the specified user password.
@>mysql-u root-p
@> Password
Mysql>update Mysql.user Set Password=password (' New password ') where user= "Phplamp" and host= "localhost";
Mysql>flush privileges;