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 13: | Line 13: | ||
<syntaxhighlight lang="bash"> | <syntaxhighlight lang="bash"> | ||
mysql -u root -p <root password> | mysql -u root -p <root password> | ||
| − | </ | + | </syntaxhighlight> |
| − | | | + | |} |
| − | } | + | |
Revision as of 00:37, 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> </syntaxhighlight> |
