Mysql 5.0, installing - Revision history

Jimbo: Reverted edits by 188.33.200.38 (Talk); changed back to last version by 79.2.222.218

2009-09-24T21:11:38Z

Reverted edits by 188.33.200.38 (Talk); changed back to last version by 79.2.222.218

188.33.200.38: /* Installation from ports */ chown -R user:group is shorter than using chgrp

2009-09-24T18:08:33Z

Installation from ports: chown -R user:group is shorter than using chgrp

79.2.222.218: /* Start MySQL */

2009-02-22T14:15:49Z

Start MySQL

George: /* Creating the root password */

2007-03-05T15:31:34Z

Creating the root password

Jimbo: Mysql installation guide moved to Mysql 5.0, installing

2006-05-28T20:14:56Z

Mysql installation guide moved to Mysql 5.0, installing

Jimbo: desnarkification

2006-05-28T20:14:36Z

desnarkification

ColdFire at 18:57, 28 May 2006

2006-05-28T18:57:08Z

New page

[[Image:Mysql.jpg]]

This MySQL guide DOES work, unlike the other MySQL guides on this wiki!

== Installation from ports ==

# su
# cd /usr/ports/databases/mysql50-server
# make install clean
# mysql_install_db
# chown -R mysql /var/db/mysql/
# chgrp -R mysql /var/db/mysql/

== Start MySQL ==

... From command:

# /usr/local/bin/mysqld_safe -user=mysql &

.. Or a handy pre-made script:

# /usr/local/etc/rc.d/mysql-server.sh

== Starting MySQL on system boot ==

# echo 'mysql_enable="YES"' >> /etc/rc.conf

== Creating the root password ==

To set the root password, replace "yourpass" with your desired password:

# mysqladmin -u root password yourpass

Note: If this command returns "command not found", type "rehash" in the CLI:

# rehash

== Final Notes ==

Job done! You now have MySQL installed and running. Give yourself a pat on the back!

[[Category:FreeBSD for Servers]]
[[Category:Ports and Packages]]

@@ Line 30: / Line 30: @@
   # mysqladmin -u root password <i>yourpass</i>
-Note: If this command returns "command not found", type "rehash" in the CLI:
+Note: If this command returns "command not found", type "rehash" in the CLI (if using C shell) :
   # rehash

← Older revision		Revision as of 20:14, 28 May 2006
Line 1:		Line 1:
	<p align="center">[[Image:Mysql.jpg]]</p>		<p align="center">[[Image:Mysql.jpg]]</p>
−
−	~~This MySQL guide <b>DOES</b> work, unlike the other MySQL guides on this wiki!~~

	== Installation from ports ==		== Installation from ports ==

@@ Line 7: / Line 7: @@
   # make install clean
   # mysql_install_db
-  # chown -R mysql:mysql /var/db/mysql/
+  # chown -R mysql /var/db/mysql/
 == Start MySQL ==

@@ Line 18: / Line 18: @@
 .. Or a handy pre-made script:
-  # /usr/local/etc/rc.d/mysql-server.sh
+  # /usr/local/etc/rc.d/mysql-server forcestart
 == Starting MySQL on system boot ==