freeBSD5.3安装mysql5.0.4数据库并用perl5.8.5测…

说明：本文档系孤雁寒枝原创，经过辛勤实验，努力编辑而成，转载无妨，请不要修改任何内容。参考不少前辈文章，不一 一列举，谨表感谢！新牛一头，如有错误，敬请好手斧正！
安装mysql5.0.4数据库
http://mysql.sd1.mirrors.redwire.net/Downloads/MySQL-5.0/mysql-max-5.0.4-beta-unknown-freebsd5.3-i386.tar.gz
freeBSD53#mount /cdrom
freeBSD53#cp /cdrom/mysql-max-5.0.4-beta-unknown-freebsd5.3-i386.tar.gz  /tmp
freeBSD53#cd /tmp
freeBSD53# tar –zxvf  mysql-max-5.0.4-beta-unknown-freebsd5.3-i386.tar.gz
freeBSD53# mv /tmp/mysql-max-5.0.4-beta-unknown-freebsd5.3-i386 /usr/local/mysql
freeBSD53# cd /usr/local/mysql/
freeBSD53# ./configure --help
NOTE: This is a MySQL binary distribution. It's ready to run, you don't
need to configure it!
To help you a bit, I am now going to create the needed MySQL databases
and start the MySQL server for you.  If you run into any trouble, please
consult the MySQL manual, that you can find in the Docs directory.
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:
./bin/mysqladmin -u root password 'new-password'
./bin/mysqladmin -u root -h freeBSD53.chenghe.com password 'new-password'
See the manual for more instructions.
You can start the MySQL daemon with:
cd . ; ./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 ./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 https://order.mysql.com
Starting the mysqld server.  You can test that it is up and running
with the command:
./bin/mysqladmin version
freeBSD53# chown: mysql: Invalid argument
Starting mysqld daemon with databases from /usr/local/mysql/data
(遇到过一个提示少libm.so.2的问题，那是我第一次下了个安装http://mysql.sd1.mirrors.redwire.net/Downloads/MySQL-5.0/mysql-max-5.0.4-beta-unknown-freebsd4.73-i386.tar.gz  请注意这个是为freebsd4.73准备的，安装时出现了libm.so.2)
freeBSD53# ps -aux | grep mysql
root    560  0.0  1.4  1656 1224  p0  I     8:10PM   0:00.09 /bin/sh ./bin/mysqld_safe --no-default
root    572  0.0 29.4 56452 26288  p0  S     8:10PM   0:03.66 /usr/local/mysql/bin/mysqld --no-default
root    619  0.0  0.2   348  208  p0  R+    8:16PM   0:00.00 grep mysql
freeBSD53# ./bin/mysqladmin -u root password "123456"

标签：

版权申明：本站文章部分自网络，如有侵权，请联系：west999com@outlook.com
特别注意：本站所有转载文章言论不代表本站观点，本站所提供的摄影照片，插画，设计作品，如需使用，请与原作者联系，版权归原作者所有