


mac uses terminal to run mysql, mysql terminal, mysql mac, mysql directory, mysql path
Jul 30, 2016 pm 01:31 PMFirst 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'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.dmg4.2 Display the list of existing command aliases
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.

Hot AI Tools

Undress AI Tool
Undress images for free

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Clothoff.io
AI clothes remover

Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

Hot Tools

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

1. The first choice for the Laravel MySQL Vue/React combination in the PHP development question and answer community is the first choice for Laravel MySQL Vue/React combination, due to its maturity in the ecosystem and high development efficiency; 2. High performance requires dependence on cache (Redis), database optimization, CDN and asynchronous queues; 3. Security must be done with input filtering, CSRF protection, HTTPS, password encryption and permission control; 4. Money optional advertising, member subscription, rewards, commissions, knowledge payment and other models, the core is to match community tone and user needs.

There are three main ways to set environment variables in PHP: 1. Global configuration through php.ini; 2. Passed through a web server (such as SetEnv of Apache or fastcgi_param of Nginx); 3. Use putenv() function in PHP scripts. Among them, php.ini is suitable for global and infrequently changing configurations, web server configuration is suitable for scenarios that need to be isolated, and putenv() is suitable for temporary variables. Persistence policies include configuration files (such as php.ini or web server configuration), .env files are loaded with dotenv library, and dynamic injection of variables in CI/CD processes. Security management sensitive information should be avoided hard-coded, and it is recommended to use.en

Why do I need SSL/TLS encryption MySQL connection? Because unencrypted connections may cause sensitive data to be intercepted, enabling SSL/TLS can prevent man-in-the-middle attacks and meet compliance requirements; 2. How to configure SSL/TLS for MySQL? You need to generate a certificate and a private key, modify the configuration file to specify the ssl-ca, ssl-cert and ssl-key paths and restart the service; 3. How to force SSL when the client connects? Implemented by specifying REQUIRESSL or REQUIREX509 when creating a user; 4. Details that are easily overlooked in SSL configuration include certificate path permissions, certificate expiration issues, and client configuration requirements.

To collect user behavior data, you need to record browsing, search, purchase and other information into the database through PHP, and clean and analyze it to explore interest preferences; 2. The selection of recommendation algorithms should be determined based on data characteristics: based on content, collaborative filtering, rules or mixed recommendations; 3. Collaborative filtering can be implemented in PHP to calculate user cosine similarity, select K nearest neighbors, weighted prediction scores and recommend high-scoring products; 4. Performance evaluation uses accuracy, recall, F1 value and CTR, conversion rate and verify the effect through A/B tests; 5. Cold start problems can be alleviated through product attributes, user registration information, popular recommendations and expert evaluations; 6. Performance optimization methods include cached recommendation results, asynchronous processing, distributed computing and SQL query optimization, thereby improving recommendation efficiency and user experience.

To achieve MySQL deployment automation, the key is to use Terraform to define resources, Ansible management configuration, Git for version control, and strengthen security and permission management. 1. Use Terraform to define MySQL instances, such as the version, type, access control and other resource attributes of AWSRDS; 2. Use AnsiblePlaybook to realize detailed configurations such as database user creation, permission settings, etc.; 3. All configuration files are included in Git management, support change tracking and collaborative development; 4. Avoid hard-coded sensitive information, use Vault or AnsibleVault to manage passwords, and set access control and minimum permission principles.

When choosing a suitable PHP framework, you need to consider comprehensively according to project needs: Laravel is suitable for rapid development and provides EloquentORM and Blade template engines, which are convenient for database operation and dynamic form rendering; Symfony is more flexible and suitable for complex systems; CodeIgniter is lightweight and suitable for simple applications with high performance requirements. 2. To ensure the accuracy of AI models, we need to start with high-quality data training, reasonable selection of evaluation indicators (such as accuracy, recall, F1 value), regular performance evaluation and model tuning, and ensure code quality through unit testing and integration testing, while continuously monitoring the input data to prevent data drift. 3. Many measures are required to protect user privacy: encrypt and store sensitive data (such as AES

PHP plays the role of connector and brain center in intelligent customer service, responsible for connecting front-end input, database storage and external AI services; 2. When implementing it, it is necessary to build a multi-layer architecture: the front-end receives user messages, the PHP back-end preprocesses and routes requests, first matches the local knowledge base, and misses, call external AI services such as OpenAI or Dialogflow to obtain intelligent reply; 3. Session management is written to MySQL and other databases by PHP to ensure context continuity; 4. Integrated AI services need to use Guzzle to send HTTP requests, safely store APIKeys, and do a good job of error handling and response analysis; 5. Database design must include sessions, messages, knowledge bases, and user tables, reasonably build indexes, ensure security and performance, and support robot memory

To enable PHP containers to support automatic construction, the core lies in configuring the continuous integration (CI) process. 1. Use Dockerfile to define the PHP environment, including basic image, extension installation, dependency management and permission settings; 2. Configure CI/CD tools such as GitLabCI, and define the build, test and deployment stages through the .gitlab-ci.yml file to achieve automatic construction, testing and deployment; 3. Integrate test frameworks such as PHPUnit to ensure that tests are automatically run after code changes; 4. Use automated deployment strategies such as Kubernetes to define deployment configuration through the deployment.yaml file; 5. Optimize Dockerfile and adopt multi-stage construction
