Questions about this topic? Sign up to ask in the talk tab.
Difference between revisions of "MySQL"
From NetSec
(→Setup on a personal computer) |
|||
| Line 14: | Line 14: | ||
mysql -u root -p <root password> | mysql -u root -p <root password> | ||
</syntax highlight> | </syntax highlight> | ||
| + | |||
|} | |} | ||
Revision as of 01:36, 20 October 2011
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 lang="bash"> mysql -u root -p <root password> </syntax highlight> |
