Guillaume: 1 revision

2008-12-03T10:38:57Z

1 revision

192.168.20.177 at 14:27, 3 October 2007

2007-10-03T14:27:09Z

New page

[[Mysql]] is a popular and powerful database server.

==Restarting==
> /etc/init.d/mysqld restart
> /etc/init.d/mysqld start
> /etc/init.d/mysqld stop

==Setting up Mysql==
Do this:
> groupadd mysql
> useradd -g mysql mysql
> cd /usr/local
> gunzip < /PATH/TO/MYSQL-VERSION-OS.tar.gz | tar xvf -
> ln -s FULL-PATH-TO-MYSQL-VERSION-OS mysql
> cd mysql
> scripts/mysql_install_db --user=mysql
> chown -R root .
> chown -R mysql data
> chgrp -R mysql .
> bin/mysqld_safe --user=mysql &

Or install it with rpm in fcX with:
> yum groupinstall mysql
> /etc/init.d/mysqld restart

==Setting up the initlevel==
Copy the ''mysql.server'' file into ''[[/etc]]/init.d'' and then create symbolic links to it in ''[[/etc]]/rc3.d'' and ''[[/etc]]/rc0.d''. Finally, before rebooting, create a symbolic link from the ''Mysql'' root folder into ''/usr/local/mysql''.
> cat support-files/mysql.server | head
# MySQL daemon start/stop script.

# Usually this is put in /etc/init.d (at least on machines SYSV R4 based
# systems) and linked to /etc/rc3.d/S99mysql and /etc/rc0.d/K01mysql.
# When this is done the mysql server will be started when the machine is
# started and shut down when the systems goes down.

...

# If you install MySQL on some other places than /usr/local/mysql, then you
# have to do one of the following things for this script to work:
#
# - Run this script from within the MySQL installation directory
# - Create a /etc/my.cnf file with the following information:
# [mysqld]
# basedir=<path-to-mysql-installation-directory>
# - Add the above to any other configuration file (for example ~/.my.ini)
# and copy my_print_defaults to /usr/bin
# - Add the path to the mysql-installation-directory to the basedir variable
# below.
#
# If you want to affect other MySQL variables, you should make your changes
# in the /etc/my.cnf, ~/.my.cnf or other MySQL configuration files.

# If you change base dir, you must also change datadir. These may get
# overwritten by settings in the MySQL configuration files.

basedir=/home/guillaume/Software/las/mysql-standard-5.0.27-linux-i686
datadir=/home/guillaume/Software/las/mysql-standard-5.0.27-linux-i686/data

==External references==
*http://www.mysql.com/

[[Category:Linux]]
[[Category:Mysql]]
[[Category:Database]]

← Older revision	Revision as of 10:38, 3 December 2008
(No difference)

Mysql - Revision history

Guillaume: 1 revision

192.168.20.177 at 14:27, 3 October 2007