mac uses terminal to run mysql, mysql terminal, mysql mac, mysql directory, mysql path

First go to the official website to download: http://www.mysql.com/downloads/

I downloaded the dmg of 5.6.11 and installed it. After the installation is completed... If you want to use the terminal to play SQL. Then start It is very long to enter: /usr/local/mysql/bin/mysql

This is inconvenient. I want to enter mysql -uroot -p1 like in cmd under windows... I checked it online... it works. Realize it.

Open the terminal and enter:

1)alias mysql=/usr/local/mysql/bin/mysql

2)alias mysqladmin=/usr/local/mysql/bin /mysqladmin

After execution, you can operate it like windows.

The second one is to set the password

We can enter: mysqladmin -u root password

In the terminal Open and close MySQL:

sudo /Library/StartupItems/MySQLCOM/MYSQLCOM [start | stop | restart]

But our installation package contains

MySQL_StartupItem.pkg

MySQL. prefPane

After installation, there will be mysql in the system preferences...

ps: Supplement the above alias method. If executed as above... then close It will be invalid if you open the terminal again. If you want long-term effects, you need to modify the file. Let it be loaded when the terminal starts. Enter in the terminal: cd ~

vim ./bash_profile

This file If the android development environment has been configured, it has been modified. We add 2 lines

alias mysql=/usr/local/mysql/bin/mysql

alias mysqladmin=/usr/local/mysql/bin/mysqladmin

Save and exit, restart the terminal or open a new window

alias command: Set the command alias

alias: usage: alias [-p] [name[=value] ... ]

1. Syntax

alias [parameter][command alias]=[original command name]

2. Function introduction

This command is mainly used for the original command Define new aliases for easy writing or memory.

3. Parameter description

Parameter Function description

-p

Send an existing command alias to the standard output device

[command alias] = [original command name] ]

Define a command alias, even if you use "alias" instead of "original command name", the actual command used in the end is still the original command

4. Example

4.1 Set command alias

Under ubuntu, we often use the command

ll

instead of the command

ls -al

but there is no such command in mac. So we used alias to implement this function, and added other parameters to make it more convenient for us to use. Execute the command

<span>#</span><span> 为了方便看文件或者目录的大小，加多一个参数h</span><span>#</span><span> 参数说明：</span><span>#</span><span> a－显示隐藏文件</span><span>#</span><span> l－显示文件的详细信息</span><span>#</span><span> h－以适合的单位进行文件或者目录大小的显示</span>alias ll='ls -alh'

kevin@uc:~/Downloads/<span>mac$ ll

total 173M

drwxrwxr</span>-x 2 kevin kevin 4.0K 9月 25 16:20 .<span>
drwxr</span>-xr-x 8 kevin kevin 4.0K 9月 29 13:59 ..

-rw-rw-r-- 1 kevin kevin 150M 9月 25 16:20 Navicat Premium <span>for</span> Mac 11.0.20 中文版.<span>dmg

</span>-rw-rw-r-- 1 kevin kevin   26 9月 25 16:20 Navicat Premium <span>for</span> Mac 11.0.20 中文版.dmg:Zone.<span>Identifier

</span>-rw-rw-r-- 1 kevin kevin  12M 9月 3 10:35 synergy-1.5.1-r2398-MacOSX108-x86_64.<span>dmg

</span>-rw-rw-r-- 1 kevin kevin  12M 9月 3 10:36 synergy-1.5.1-r2398-MacOSX109-x86_64.dmg

alias -p

The console will output the following results:

kevin@uc:~$ alias -p

alias ll='ls -alh'

5. Experience tips

Use this command Some longer commands can be simplified.

When using this command, the user must use single quotes ' ' to surround the original command to prevent special characters from causing errors.

The effect of this command is limited to the login operation. If you want to be able to use these command aliases every time you log in, you can store the corresponding alias commands in the bash initialization file "~/.bash_profile".

6. View the original command of the command alias

To get the original command of the command alias, you can use the command "type" to achieve it, enter the following command:

type ll #Display the original command of the command alias

The console will output:

ll is aliased to `ls -alh'

The above introduces how to use the terminal to run mysql on mac, mysql terminal, mysql mac, mysql directory, mysql path, including the content. I hope it will be helpful to friends who are interested in PHP tutorials.