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
Now Under /var/db/mysql there is two dir : mysql and test
I go under test and I launch mysqld_safe
So I watch in the Lodelservoo.workgroup.err logfile
then I chmod 777 /var/db/mysql
and I try again the mysqld_safe
So I watch one more time in the Lodelservoo.workgroup.err logfile
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
Thanks everybody
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)