I want to that the moderators for allowing me to join your group. I
am having a problem with starting mysql.
OS: FreeBSD 5.3
Installed packages(brief):
apache-2.1.4
mysql-administrator-1.0.20
mysql-client-4.0.24_1
mysql-server-4.0.24_1
php5-mysql-5.0.2
This is what I get:
208# mysqld_safe
Starting mysqld daemon with databases from /var/db/mysql
Abort trap
STOPPING server from pid file /var/db/mysql/208.35.141.195.pid
050425 11:37:09 mysqld ended
208# mysql start
ERROR 2002: Can't connect to local MySQL server through
socket '/tmp/mysql.sock' (61)
208# /usr/local/bin/safe_mysqld --user=mysql &
[1] 743
/usr/local/bin/safe_mysqld: Command not found.
208# mysql -u root -p<pass>
Missing name for redirect.
208# mysql_install_db
Installing all prepared tables
050425 11:45:52 /usr/local/libexec/mysqld: Shutdown Complete
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/local/bin/mysqladmin -u root password 'new-password'
/usr/local/bin/mysqladmin -u root -h 208.35.141.195 password 'new-
password'
See the manual for more instructions.
NOTE: If you are upgrading from a MySQL <= 3.22.10 you should run
the /usr/local/bin/mysql_fix_privilege_tables. Otherwise you will
not be
able to use the new GRANT command!
You can start the MySQL daemon with:
cd /usr/local ; /usr/local/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/local/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
Sorry for this being so long. I am not all that new to FreeBSD but
am new to mysql. I have been running FreeBSD servers at work and
home serving DNS, http, ftp, samba, qmail w/squirrelmail...but was
recently asked to install mysql so that they can use a buliten board.
I have googled until I was blue in the face here and have come up
with nothing. Anyhelp would be greatly appreciated.
The PHP_mySQL group is dedicated to learn more about the PHP_mySQL web database
possibilities through group learning.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/php_mysql/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
