#CREATE DATABASE MYSQL LINUX HOW TO#
#CREATE DATABASE MYSQL LINUX INSTALL#
#CREATE DATABASE MYSQL LINUX FULL#
#CREATE DATABASE MYSQL LINUX CODE#
#CREATE DATABASE MYSQL LINUX PASSWORD#

If you require a dedicated web server running MySQL and phpMyAdmin please visit our Web Hosting Services page.īrowse to your phpMyAdmin URL using your Internet Web Browser, and login using your root or dba user login as shown.

You will need to have access to an instance of phpMyAdmin appropriately configured to administrate the MySQL server.

You will require a root or DBA user login to the MySQL server, or a user login with permission to create new databases.

#CREATE DATABASE MYSQL LINUX HOW TO#

This tutorial illustrates how to create a new database and a new user to access that database on a MySQL Server using phpMyAdmin.

#CREATE DATABASE MYSQL LINUX CODE#

Source code for this post is available on Github - is an open source project.PhpMyAdmin is a popular web-based administration tool used to administrate MySQL servers and databases. The pcmDB database will be than saved into the single file pcmdb-backup-2014.06.22.sql, which you can later import as mentioned on the previous step. If you ever want to backup up the database you can use the mysqldump program, by issuing a command similar to the following on the command line: `` shell> mysqldump pcmdb -u pcm -p -h 127.0.0.1 -single-transaction > c:/tmp/pcmdb-backup-2014.06.22.sql | 38 | travel_transport | Travel & Transport | | 37 | family_children | Family & children | | 35 | hobby_freetime | Hobby & free time | | 28 | religion_spirituality | Religion | sql script file, like prepare_database_for_import.sql, and run the following command in the OS shell: shell> mysql mysql -p -u pcm pcmDB mysql -host=localhost -user=pcm -password=pcm_pw Instead of executing all these commands manually, you can alternatively put them in a. | localhost | pcm | Y | Y | Y | Y | Y | Y | Mysql> GRANT ALL PRIVILEGES ON *.* TO verify privileges were set (Y)

#CREATE DATABASE MYSQL LINUX 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 |

#CREATE DATABASE MYSQL LINUX PASSWORD#

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.

#CREATE DATABASE MYSQL LINUX 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.

Create database mysql linux