forasfen.blogg.se - Mysql command line

Mysql command line install#
Mysql command line full#

Mysql> GRANT ALL PRIVILEGES ON *.* TO verify privileges were set (Y)

Mysql command line full#

grant full privileges to the user, for easy development | localhost | pcm | N | N | N | N | N | N | | host | user | select_priv | insert_priv | update_priv | delete_priv | create_priv | alter_priv | Mysql> SELECT host, user, select_priv, insert_priv, update_priv, delete_priv, create_priv, alter_priv, password FROM er WHERE user='pcm' Mysql> select host, user, password from er Mysql> CREATE USER IDENTIFIED BY 'pcm_pw' Mysql> DROP USER create the development user 'pcm' identified by the password 'pcm_pw' Once you are connected to the MySQL command line do following the steps: - delete the pcmDB database if existent Create database and the (development) DB user You will be asker for your root’s password 3. Now use it to connect to the MySQL console: shell> mysql -host=localhost -user=root -p When installing the MySQL server, you were asked to set up a “root” user.

Mysql command line install#

Optional – install MySQL Workbench for easy DB development and administration.

Set up the environment variables – the MySQL programs are installed in MySQL_installation_path/bin, so you’d want this location added to the PATH variable to be easily invoked from shells and command lines.

You can see in this blog post – Optimizing MySQL server settings – how the MySQL database is configured in production for

Download MySQL Community Server version 5.5 or 5.6 for the platform of your choice.įor Windows place the configuration file where the MySQL server is installed – the my.ini file from above is an example used on a Windows 7 machineįor linux you need to use.

Note: Although the steps presented here refer to the database backing, they should be valid for any MySQL database you might want to setup either in Linux or Windows. The content of that file is basically reproduced here, as “back-up”, for future reference and why not?, it might also serve others in the mean time. We use currently for a MySQL database and because we’ve recently gone open source on GitHub, we’ve created a README.md to explain the setup of the database.