Good Day MYSQL helpers,
On Redhat 8 we were running a FAQman software. A few days ago, mysql was
not working, come to find out that the safe_mysql file was missing.
This is the error that we get even though we can start up the safe_mysql
ยป MySQL Error
There was an error connecting to the
Can't start ./safte_mysql. Error message:
touch: /usr/local/mysql/var/gemini.err cannot create
chown: /usr/local/mysql/var/gemini.err: No such file or directory
Starting mysqld daemon with databases from /usr/local/mysql/var
./safe_mysqld: /usr/local/mysql/var/gemini.err: cannot create
So I created
ramer
>Cc: [EMAIL PROTECTED]
>Subject: Re: Can access DBs when started w/ safe_mysql but not with
>mysqld
>
>
>The mysql user should own the databases and files, not root.
>
>David Kramer wrote:
>
>>I am able to access all of the database instances that I have c
TED]]
Sent: Friday, July 12, 2002 11:08 AM
To: David Kramer
Cc: [EMAIL PROTECTED]
Subject: Re: Can access DBs when started w/ safe_mysql but not with
mysqld
The mysql user should own the databases and files, not root.
David Kramer wrote:
>I am able to access all of the database instance
The mysql user should own the databases and files, not root.
David Kramer wrote:
>I am able to access all of the database instances that I have created when
>starting Mysql with safe_mysql(as root user). As soon as I start mysql any
>other way, I keep getting the Access Denied Error.
I am able to access all of the database instances that I have created when
starting Mysql with safe_mysql(as root user). As soon as I start mysql any
other way, I keep getting the Access Denied Error. Can root only access DBs
under safe_mysql? Im completely lost here
Thanks,
DK
David
Thank you for your contribution.
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com
--
>Description:
Attached is a short manpage bugfix.
>How-To-Repeat:
man -k safe_mysqld
>Fix:
--- safe_mysqld.1.orig Tue Nov 27 02:19:05 2001
+++ safe_mysqld.1 Tue Nov 27 02:19:56 2001
@@ -1,8 +1,7 @@
-.TH SAFE_MYSQLD "1" "19 December 2
ALL-SOURCE file
> I can get to the last instruction -
>
> /usr/local/mysql/bin/safe_mysql --user=mysql &
>
> I get a No such file or directory file, which is
> correct, I dont have safe_mysql anywhere on the system
>
> Did I miss a step so
Following the instructions in the INSTALL-SOURCE file
I can get to the last instruction -
/usr/local/mysql/bin/safe_mysql --user=mysql &
I get a No such file or directory file, which is
correct, I dont have safe_mysql anywhere on the system
Did I miss a step somewhere?
Running mysql-4.0
Keith Woodworth writes:
> I dont have a my.cnf but now need to relocate the database on the system,
> where does mysql get the environtment var's it uses to start by default?
It doesn't get them from env vars AFAIK, but you can change them at
compile time. Also, there are command-line parameter
Need to change locations of where mysql is storing all its database info.
When the system starts it initiates safe_mysqld and starts with the base
dir of /usr/var/local
I dont have a my.cnf but now need to relocate the database on the system,
where does mysql get the environtment var's it uses
Plesae review your log files!
On Fri, 31 Aug 2001, nirav shah wrote:
> Dear friends,
>
> I have got mysql current 3.23 version installed
> with linux in my pc.
>
> but it is not working properly when i give
> command
>
> $ safe_mysqld
>
> Here after few seconds, it dis
You need to look at the mysql error log, usually in your data directory.
99% of the time, if this is your first attempt to use MySQL you don't have
the permissions tables created yet. There should be a mysql_install_db
script that cam with your system, see if you have that, and try running
Dear friends,
I have got mysql current 3.23 version installed
with linux in my pc.
but it is not working properly when i give
command
$ safe_mysqld
Here after few seconds, it displays message that
mysqld ended.
So i am not able to start the server.
When i verified m
15 matches
Mail list logo