Home >Backend Development >PHP Tutorial >mac uses terminal to run mysql, mysql terminal, mysql mac, mysql directory, mysql path, macmysql_PHP tutorial

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

WBOY
WBOYOriginal
2016-07-13 09:44:411131browse

Mac uses the terminal to run mysql, mysql terminal, mysql mac, mysql directory, mysql path, macmysql

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 you have to enter a long string at the beginning: /usr/local/mysql/bin/mysql

This is inconvenient. I want to enter mysql -uroot -p1 like in cmd under windows... I checked online. It can be done.

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

Open and close MySQL in the terminal:

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

But there is

in our installation package

MySQL_StartupItem.pkg

MySQL.prefPane

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

ps: Supplement the above alias method. If you execute it as above, then closing the terminal and reopening it will have no effect. If you want long-term effects, you need to modify the file and let the terminal load it when it starts.

Input in terminal: cd ~

vim ./bash_profile

This file has been 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 and exit, restart the terminal or open a new window

alias command: Set command alias

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

1. Grammar

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

2. Function introduction

This command is mainly used to define a new alias for the original command to facilitate 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 will often use the command

ll

instead of 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 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'

After the command is executed, we execute ll once to try. The console output is as follows:

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

4.2 Display the existing command alias list

alias -p

The console will output the following results:

kevin@uc:~$ alias -p

alias ll='ls -alh'

5. Experience skills

Use this command to simplify some long commands.

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'

www.bkjia.comtruehttp: //www.bkjia.com/PHPjc/1048742.htmlTechArticlemac uses the terminal to run mysql, mysql terminal, mysql mac, mysql directory, mysql path, macmysql First go to the official website to download: http://www.mysql.com/downloads/ I downloaded the dmg of 5.6.11 and installed it...
Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn