MySQL, Simple Installation - Revision history

Sidetone: /* Overview */

2014-12-18T01:14:00Z

Overview

2010-01-16T14:34:09Z

2006-08-29T00:26:57Z

'''Configuration'''

2005-09-02T13:21:12Z

'''Overview'''

2005-09-02T13:20:25Z

'''Overview'''

2005-09-02T06:46:06Z

Reverted edit of Mwn, changed back to last version by Jimbo

2005-09-01T21:40:31Z

2005-08-16T03:24:01Z

2005-08-16T03:05:30Z

'''Adding new users'''

2005-08-16T02:55:52Z

'''Adding new users'''

@@ Line 9: / Line 9: @@
 '''Install MySQL from ports'''
-First, we need to install the port. Make sure you're logged in as [[root]], and as always, update your ports tree with [[CVSUP]] before doing any major software installations.  You also need to have working DNS resolution for your machine's hostname - check the output of the [[hostname]] command, and make sure you can [[ssh]] into it (and that it is your box!).  If you don't have working DNS resolution, you will need to either fix it or temporarily hack your way around the problem by issuing a '''hostname localhost''' command to set the machine's name to localhost.
+First, we need to install the port. Make sure you're logged in as [[root]], and as always, update your ports tree with [[csup]] before doing any major software installations.  You also need to have working DNS resolution for your machine's hostname - check the output of the [[hostname]] command, and make sure you can [[ssh]] into it (and that it is your box!).  If you don't have working DNS resolution, you will need to either fix it or temporarily hack your way around the problem by issuing a '''hostname localhost''' command to set the machine's name to localhost.
   oyabun# cd /usr/ports/databases/mysql40-server/

@@ Line 18: / Line 18: @@
 When the installation is done, you'll see something very similar to this:
-<pre name="I used pre on this because this is a lot of text.">
+<pre>
 To start mysqld at boot time you have to copy support-files/mysql.server
 to the right place for your system
@@ Line 95: / Line 95: @@
 You'll notice mysql's startup script notified you that it started by saying "''mysql'' - there's no carriage return after a startup script calls out its notification like that, so instead of seeing a completely separate line, you see "mysqloyabun#" instead of "oyabun#" as the next command prompt.
-Note: by default, your new MySQL installation does not have a root password set.  If you want to keep [[shell users]] from logging into it as root, or if you want remote SQL clients to be able to authenticate themselves as root, you'll need to [[MySQL:_set_root_password|set a root password]] now.
+Raven's Note: by default, your new MySQL installation does not have a root password set.  If you want to keep [[shell users]] from logging into it as root, or if you want remote SQL clients to be able to authenticate themselves as root, you'll need to [[MySQL:_set_root_password|set a root password]] now.
 =='''Testing the installation'''==

@@ Line 9: / Line 9: @@
 '''Install MySQL from ports'''
-First, we need to install the port. Make sure you're logged in as [[root]], and as always, update your ports tree with [[CVSUP]] before doing any major software installations.  You also need to have working DNS resolution for your machine's hostname - check the output of '''hostname''' and make sure you can [[ssh]] into it (and that it is your box!).  If you don't have working DNS resolution, you will need to either fix it or temporarily hack your way around the problem by issuing a '''hostname localhost''' command to set the machine's name to localhost.
+First, we need to install the port. Make sure you're logged in as [[root]], and as always, update your ports tree with [[CVSUP]] before doing any major software installations.  You also need to have working DNS resolution for your machine's hostname - check the output of the [[hostname]] command, and make sure you can [[ssh]] into it (and that it is your box!).  If you don't have working DNS resolution, you will need to either fix it or temporarily hack your way around the problem by issuing a '''hostname localhost''' command to set the machine's name to localhost.
   oyabun# cd /usr/ports/databases/mysql40-server/

@@ Line 9: / Line 9: @@
 '''Install MySQL from ports'''
-First, we need to install the port. Make sure you're logged in as [[root]], and as always, update your ports tree with [[CVSUP]] before doing any major software installations.
+First, we need to install the port. Make sure you're logged in as [[root]], and as always, update your ports tree with [[CVSUP]] before doing any major software installations.  You also need to have working DNS resolution for your machine's hostname - check the output of '''hostname''' and make sure you can [[ssh]] into it (and that it is your box!).  If you don't have working DNS resolution, you will need to either fix it or temporarily hack your way around the problem by issuing a '''hostname localhost''' command to set the machine's name to localhost.
   oyabun# cd /usr/ports/databases/mysql40-server/

@@ Line 11: / Line 11: @@
 First, we need to install the port. Make sure you're logged in as [[root]], and as always, update your ports tree with [[CVSUP]] before doing any major software installations.
   oyabun# cd /usr/ports/databases/mysql40-server/
   oyabun# make install clean

@@ Line 122: / Line 122: @@
   Query OK, 0 rows affected (0.00 sec)
-That's it! You now have MySQL added to your machine, and you begin using php scripts or other MySQL tools.
+That's it! You now have MySQL added to your machine, and you begin using php scripts or other MySQL tools.  You can find more articles on how to do things with MySQL at the [[MySQL|MySQL Disambiguation page]].
-−
-−
-=='''Adding new users'''==
-−
-To add new users to mysql use the following commands (if you haven't set a password for the mysql root user, leave off the '''-p'''):
-−
-  oyabun# '''mysql --user=root mysql -p'''
- password:
- > GRANT ALL PRIVILEGES ON *.* TO user@localhost IDENTIFIED BY 'pass' WITH GRANT OPTION;
-−
-Nore: that command grants full privileges on ALL databases to "user@localhost", effectively creating a new mysql root user, which is usually not what you want.  More frequently, you will want to '''GRANT ALL PRIVILEGES ON [[databasename]].*''' or something similar.
-−
-==External Links===
-−
-[http://dev.mysql.com/doc/mysql/en/adding-users.html link Mysql-adding-users]
-[http://sunsite.mff.cuni.cz/MIRRORS/ftp.mysql.com/doc/en/Adding_users.html link Mysql-adding-users2]
 [[Category : Common Tasks]]

@@ Line 130: / Line 130: @@
 oyabun# mysql --user=root mysql
 ''(Add -p to that command if you have set a password for root access to mysql)''
 This next command will allow full access to the new user
@@ Line 136: / Line 137: @@
 > GRANT ALL PRIVILEGES ON *.* TO user@localhost IDENTIFIED BY 'pass' WITH GRANT OPTION;
-''Warning  You may not want full access to this user.'' Therefore you will have to limit what privileges that user has.  Refer to the GRANT command with these links:
+'''Warning  You may not want full access to this user.''' Therefore you will have to limit what privileges that user has.  Refer to the GRANT command with these links:
 [http://dev.mysql.com/doc/mysql/en/adding-users.html link Mysql-adding-users]