Questions about this topic? Sign up to ask in the talk tab.

MySQL

From NetSec
Revision as of 00:35, 20 October 2011 by DPYJulietowbaijc (Talk | contribs) (Setup on a personal computer)

Jump to: navigation, search

MySQL Setup

In order to run MySQL you will need a MySQL server to work with - you can establish a server on one of your own computers, or use a webserver with MySQL installed.

Setup on a personal computer

Once MySQL is installed on your computer and the MySQL daemon is running (in Arch, /etc/rc.d/mysqld start), the next step is to establish users. If you defined a root MySQL password on setup, you can use this to establish a new user; otherwise, just hit enter at any password prompts you encounter.

In order to set up your MySQL databases, you'll first need to log into MySQL - at this point the only MySQl user will be your root user, so log in with:

<syntaxhighlight="c"> mysql -u root -p <root password> </syntaxhighlight>