first go to the official website download: http://www.mysql.com/downloads/
I downloaded the 5.6.11 dmg and then installed, after the installation is complete. If you want to use the terminal to play SQL. So start by typing a long:/usr/local/mysql/bin/mysql
This is not convenient ah, good imagination under the Windows cmd inside like input mysql-uroot-p1 so ... On the Internet to check the next. can achieve drip.
Open Terminal, enter:
1) Alias Mysql=/usr/local/mysql/bin/mysql
2) Alias Mysqladmin=/usr/local/mysql/bin/mysqladmin
When you're done, you can do it like windows.
The second one is to set the password
We can enter: mysqladmin-u root password
Turn on MySQL and shutdown under terminal:
sudo/library/startupitems/mysqlcom/mysqlcom [Start | stop | restart]
But we have a package inside.
mysql_startupitem.pkg
Mysql.prefpane
After installation, there will be MySQL in the system Preferences ....
PS: Add the alias method above. If you follow the above: Then shut down the terminal and then open it is invalid. Want long-term effective fruit. You need to modify the file. Load the terminal when it is started.
In Terminal input: cd ~
Vim./bash_profile
This file is modified if the Android development environment has been configured. We add 2 lines
Alias Mysql=/usr/local/mysql/bin/mysql
Alias Mysqladmin=/usr/local/mysql/bin/mysqladmin
Save exit, restart Terminal or open a new window
Alias directive: Setting command aliases
Alias:usage:alias [-P] [Name[=value] ...]
1. Syntax
alias [parameter] [command alias]=[original command name]
2. Function Introduction
This directive is primarily used to define new aliases for the original command for writing or remembering.
3. Parameter description
Parameter function Description
-P
Send a command alias that already exists to the standard output device
[Command alias]=[original command name]
defines the command alias, which is the use of "alias" instead of "original command name", but the final command used is still the original command
4. Example
4.1 Setting Command aliases
Under Ubuntu, we will often use commands
ll
instead of an order.
Ls-al
But this command is not in the Mac. We then use alias to implement this function, and add other parameters to make it easier for us to use. Execute command
# to make it easier to see the size of the file or directory, add one more parameter H # parameter Description: # A- show hidden files # L-Display file details # H. Display of file or directory size in a suitable unit alias ll= ' Ls-alh '
Once the command is executed, we perform a ll attempt and the console output is as follows:
kevin@uc:~/downloads/mac$ lltotal 173Mdrwxrwxrx 2 Kevin Kevin 4.0K September 25 16:20. drwxr for Mac 11.0.20 Chinese version. DMG-rw-rw-r--1 Kevin Kevin for Mac 11.0.20 Chinese version. Dmg:zone. Identifier-rw-rw-r--1 Kevin Kevin 12M September 3 10:35 synergy-1.5.1-r2398-macosx108-x86_64. DMG-rw-rw-r--1 Kevin Kevin 12M September 3 10:36 synergy-1.5.1-r2398-macosx109-x86_64.dmg
4.2 Displaying a list of command aliases that already exist
Alias-p
The console will output the following results:
kevin@uc:~$ alias-p
Alias Ll= ' Ls-alh '
5. Experience and Skills
Use this directive to simplify some of the longer commands.
When using this directive, the user must use single quotation marks to "cause the original command to be used to prevent special characters from causing an error.
The function of the instruction is limited to the operation of the login. To be able to use these command aliases every time you log in, you can store the alias command in Bash's initialization file "~/.bash_profile".
6. View the command alias's original command
To obtain the original command for the command alias, you can do so by using the directive "type", and enter the following command:
Type LL #显示命令别名的原始命令
The console will output:
ll is aliased to ' Ls-alh '
The above describes the Mac using terminal running Mysql,mysql terminal, MySQL mac,mysql directory, MySQL path, including the aspects of the content, want to be interested in PHP tutorial friends helpful.