Difference between revisions of "Adding a MySQL Database, User, and Assigning Privileges through the MySQL command line"
Docs admin (Talk | contribs) (test) |
(No difference)
|
Revision as of 19:33, 28 September 2012
In the absence of a control panel, MySQL databases and users will need to be added to your MySQL service through the MySQL command line. A database and user are often the first pieces of information popular web scripts like Joomla and Wordpress require for installation. If you're installing a popular script for your web site, this will likely be your first place to start. During this process, be sure to take note of the database, username, and password you setup. You'll need to supply this information when you install a script for your site. 1) Login to your server via SSH as the root user. 2) Access the MySQL command line using the username 'root' and the root MySQL password. Note that the MySQL root password is set during MySQL installation and is different from your server's root SSH password. Enter the following command and provide the MySQL root password when prompted:
Enter password:
Query OK, 1 row affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)