MYSQL
Destructions for setting up MySQL on hopperprime
hopperprime# cd /usr/ports/databases/mysql50-server/ make make install
Remember to run mysql_upgrade (with the optional --datadir=<dbdir> flag) the first time you start the MySQL server after an upgrade from an earlier version.
This port has installed the following files, which may act as network
servers and may therefore pose a remote security risk to the system.
/usr/local/libexec/mysqld
This port has installed the following startup scripts, which may cause
these network services to be started at boot time.
/usr/local/etc/rc.d/mysql-server
More information can be found at http://www.mysql.com/
first time install you need configure the mysql database tables
Note: this must be done under the mysql user or use --user=mysql /usr/local/bin/mysql_install_db --user=mysql
set the root password
mysqladmin -u root -h hopperprime.cluster.earlham.edu password passwdhere
test to make sure the password is set.
hopperprime# mysqlshow -u root mysqlshow: Access denied for user 'root'@'localhost' (using password: NO) hopperprime# mysqlshow -u root -p Enter password: +--------------------+ | Databases | +--------------------+ | information_schema | | mysql | | test | +--------------------+ also set the root @localhost password
hopperprime# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 5.0.41 FreeBSD port: mysql-server-5.0.41
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> select host, user from mysql.user; +---------------------------------+------+ | host | user | +---------------------------------+------+ | 127.0.0.1 | root | | hopperprime.cluster.earlham.edu | root | | localhost | root | +---------------------------------+------+ 3 rows in set (0.00 sec)
mysql> SET PASSWORD FOR 'root'@'hopperprime.cluster.earlham.edu' = PASSWORD('passwordhere'); Query OK, 0 rows affected (0.00 sec)
mysql>quit
also add mysql_enable="YES" to /etc/rc.conf
mysql is now installed
hopperprime# locate p5-DBD-mysql cd /usr/ports/databases/p5-DBD-mysql
make; make install
hopperprime# locate php5-mysql cd /usr/ports/databases/php5-mysql make; make install hopperprime# make install ===> Installing for php5-mysql-5.2.2 ===> php5-mysql-5.2.2 depends on file: /usr/local/include/php/main/php.h - found ===> php5-mysql-5.2.2 depends on shared library: mysqlclient.15 - found ===> Generating temporary packing list ===> Checking if databases/php5-mysql already installed ===> Registering installation for php5-mysql-5.2.2
The following line has been added to your /usr/local/etc/php/extensions.ini configuration file to automatically load the installed extension:
extension=mysql.so
hopperprime# pkg_info | grep mysql mysql-client-5.0.41 Multithreaded SQL database (client) mysql-server-5.0.41 Multithreaded SQL database (server) p5-DBD-mysql-4.003 MySQL driver for the Perl5 Database Interface (DBI) php5-mysql-5.2.2 The mysql shared extension for php
