Inrichten server Scharnhorst #
Het betreft een OpenVZ (VPS) met Fedora Core 5.
Na de (reeds lange tijd uitgevoerde) installatie vanuit OpenVZ, moet er nu MySQL bij op.
Het volgende gedaan :
- yum install mysql
- yum -y groupinstall "MySQL Database"
- /etc/init.d/mysqld start :
[root@scharnhorst init.d]# ./mysqld start
Initializing MySQL database: Installing all prepared tables
Fill help tables
To start mysqld at boot time you have to copy support-files/mysql.server
to the right place for your system
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h scharnhorst password 'new-password'
See the manual for more instructions.
You can start the MySQL daemon with:
cd /usr ; /usr/bin/mysqld_safe &
You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory:
cd sql-bench ; perl run-all-tests
Please report any problems with the /usr/bin/mysqlbug script!
The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at http://shop.mysql.com
[ OK ]
Starting MySQL: [ OK ]
- /usr/bin/mysqladmin -u root password XXXXXX
- op blackpearl: mysqldump krmdb -u root -p > mysqldumpkrm.sql
- overpiepen mysqldumpkrm.sql naar scharnhorst
- mysql -u root -p en dan:
- create database krmdb
- use krmdb;
- source mysqldumpkrm.sql
- en test: select count(*) from peuter ==> 975 rijen
- aanmaken user: create user 'kruimeluser'@'localhost' identified by XXXXXXXX;
- overpiepen mysql connector:
blackpearl:/usr/local/tomcat/lib # scp mysql-connector-java-3.1.8-bin.jar root@scharnhorst:/usr/local/tomcat/lib root@scharnhorst's password: mysql-connector-java-3.1.8-bin.jar 100% 400KB 399.6KB/s 00:00
- aanleggen log directory voor krm mkdir /usr/local/tomcat/logs/krm
T O D O#
- -
