I installed mysql41 this is the end of the installation
Quote:
You already have a group "mysql", so I will use it.
mysql:*:88:88::0:0:MySQL Daemon:/var/db/mysql:/sbin/nologin
You already have a user "mysql", so I will use it.
===> Compressing manual pages for mysql-server-4.1.11_1
===> Registering installation for mysql-server-4.1.11_1
===> SECURITY REPORT:
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
If there are vulnerabilities in these programs there may be a security
risk to the system. FreeBSD makes no guarantee about the security of
ports included in the Ports Collection. Please type 'make deinstall'
to deinstall the port if this is a concern.
For more information, and contact details about the security
status of this software, see the following webpage: http://www.mysql.com/
but when I try to launch the mysqld daemon it write this:
Quote:
$ /usr/local/libexec/mysqld
050504 15:31:13 [Warning] Can't create test file /var/db/mysql/Lodelservoo.lower-test
/usr/local/libexec/mysqld: Can't change dir to '/var/db/mysql/' (Errcode: 13)
050504 15:31:13 [ERROR] Aborting
I verify that the dir mysql existed under /var/db, but it doesn't so naively I created it and launch again the mysqld but each time i have the same error message.
If someone know something about it he is welcoming
then secured the initial accounts, etc, etc, etc. This stuff is all covered in the MySQL manual, which should be installed on your system in several formats in:
I reinstall the port mysql41-server, but I have still nothing like mysql-server.sh under /usr/local/etc/rc.d/
Nevermind I follow instruction you give me
First the mysql_install_db
Code:
Lodelservoo# /usr/local/bin/mysql_install_db
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/local/bin/mysqladmin -u root password 'new-password'
/usr/local/bin/mysqladmin -u root -h Lodelservoo.workgroup password 'new-password'
See the manual for more instructions.
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
Lodelservoo#
Now Under /var/db/mysql there is two dir : mysql and test
I go under test and I launch mysqld_safe
Code:
Lodelservoo# /usr/local/bin/mysqld_safe --user=mysql
Starting mysqld daemon with databases from /var/db/mysql
STOPPING server from pid file /var/db/mysql/Lodelservoo.workgroup.pid
050505 13:18:22 mysqld ended
So I watch in the Lodelservoo.workgroup.err logfile
Code:
Lodelservoo# vi Lodelservoo.workgroup.err
050505 13:18:22 mysqld started
050505 13:18:22 [ERROR] bdb: /var/db/mysql: Permission denied
050505 13:18:22 [ERROR] bdb: /var/db/mysql/log.0000000001: Permission denied
050505 13:18:22 [ERROR] bdb: PANIC: Permission denied
050505 13:18:22 [ERROR] bdb: PANIC: DB_RUNRECOVERY: Fatal error, run database recovery
050505 13:18:22 [ERROR] bdb: fatal region error detected; run recovery
050505 13:18:22 [ERROR] bdb: /var/db/mysql: Permission denied
050505 13:18:22 InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'create'.
InnoDB: Cannot continue operation.
050505 13:18:22 mysqld ended
then I chmod 777 /var/db/mysql
and I try again the mysqld_safe
Code:
Lodelservoo# /usr/local/bin/mysqld_safe --user=mysql
Starting mysqld daemon with databases from /var/db/mysql
STOPPING server from pid file /var/db/mysql/Lodelservoo.workgroup.pid
050505 13:22:01 mysqld ended
So I watch one more time in the Lodelservoo.workgroup.err logfile
Code:
Lodelservoo# vi Lodelservoo.workgroup.err
050505 13:22:00 mysqld started
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
050505 13:22:00 InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
050505 13:22:01 InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
050505 13:22:01 InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
050505 13:22:01 InnoDB: Started; log sequence number 0 0
050505 13:22:01 [ERROR] /usr/local/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
050505 13:22:01 [ERROR] Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' (errno:
13)
050505 13:22:01 mysqld ended
I am lost, I don't understand why it can't find the host.rfm whereas I launch mysqld_safe in the work directory /var/db/mysql/test and the host.frm exist at this place /var/db/mysql/mysql/host.frm
I don't understand why I have to chmod 777 mysql whereas a 700 should be enough
Last edited by SoulCoder; 05-05-2005 at 08:48 AM..
, and you've tried setting
--datadir=/path/to/my/data/directory but you
still get the same error, it may be because the
databases installed in the mysql data directory
(usually /var/lib/mysql) are not owned by the
mysql daemon, but by the user who ran
mysql_install_db. chown them to mysql and chgrp
them to the appropriate group e.g.
chown -R mysql /var/lib/mysql/mysql
chgrp -R daemons /var/lib/mysql/mysql
And now the mysqld daeomn run
the content of the logfile is
Code:
050505 15:40:03 mysqld started
050505 15:40:04 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
050505 15:40:04 InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 43634.
InnoDB: Doing recovery: scanned up to log sequence number 0 43634
050505 15:40:04 InnoDB: Flushing modified pages from the buffer pool...
050505 15:40:04 InnoDB: Started; log sequence number 0 43634
/usr/local/libexec/mysqld: ready for connections.
Version: '4.1.11' socket: '/tmp/mysql.sock' port: 3306 FreeBSD port: mysql-server-4.1.11_1
~
Hello, I have the problem that mysql wont start at boot.
First, even after the install of mysql41-server ports there was no /usr/local/etc/rc.d/mysql-server.sh
So Naevely I copy the /usr/ports/database/mysql41-server/files/mysql-server.in.sh at the usual place /usr/local/etc/rc.d/, then I wrote mysql_enable="YES" in the rc.conf. The result is nothing, I'm still having to start mysql manually by /usr/local/bin/mysqld_safe
Does some one know something about it
Thanks in advance
I install from scratch all the installation, the mysqld-server is at the right place and now it's run well
Special thanks to Jolko for his help
this topic can be close
Last edited by SoulCoder; 05-11-2005 at 02:11 PM..
I am trying to start a server for a class I am in but... mysql won't start with this error ( ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) )
---------- Post updated at 03:51 PM ---------- Previous update was at 03:50 PM ----------
... (2 Replies)
I want to do something very very bad. I want to create a button that restarts mysqld. Why is irrelevant for my issue.
Here is my php script ...
<?php
if(isset($_POST)){
exec("sudo /etc/init.d/mysqld restart");
}
?>
<form method="POST">
<input type="submit" name="restart"... (3 Replies)
Hello,
I have recently installed MySql and I encourage an error.
I am using Fedora 15 and when I am trying to start mysqld service i am getting
the following error message:
Starting mysqld (via systemctl): Job failed. See system logs and 'systemctl status' for details. If I try to start it... (4 Replies)
Hi bros
I have a VPS 512mb (Burst 2GB) with Kloxo installed and hosting few sites on it with not much traffic
I am facing high cpu load for the last few days and seems mysqld is overloading the cpu
Any suggestion will be appreciated
Regards
Rizwan
Top output is as under
top -... (2 Replies)
Hi,
I am experiencing frequent system hangs, hard kernel panics, etc almost thrice a day. The system would be totally unresponsive and the only way is to reboot is hard power recycling (plug out the power cable and plug in back after 30 secs). I enabled kdump, but unfortunately the kdump files... (3 Replies)