Questions about this topic? Sign up to ask in the talk tab.
Difference between revisions of "MySQL"
From NetSec
(→MySQl Setup) |
|||
| Line 1: | Line 1: | ||
| − | == | + | == 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. | 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. | ||
| Line 6: | Line 6: | ||
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. | 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: | ||
| + | |||
| + | {| class="wikitable" | ||
| + | | | ||
| + | <syntaxhighlight="bash"> | ||
| + | mysql -u root -p <root password> | ||
| + | </syntaxhighlight> | ||
| + | |} | ||
Revision as of 01:35, 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="bash"> mysql -u root -p <root password> </syntaxhighlight> |
