Hello all,
Had a normal MySQL shutdown, reboot and then this happens:
161010 10:58:30 [Note] Plugin 'FEDERATED' is disabled.
161010 10:58:31 InnoDB: The InnoDB memory heap is disabled
161010 10:58:31 InnoDB: Mutexes and rw_locks use Windows interlocked functions
161010 10:58:31 InnoDB:
Have u executed mysql_install_db?
On 15-May-2015 1:31 pm, Jørn Dahl-Stamnes sq...@dahl-stamnes.net wrote:
Hello,
I have reinstalled a test server after a disk crash. I upgraded from an
older Fedora Core (don't
remember the version) to Fedora Core 21.
Then I installed Mysql 5.7.7 from RPM.
Hello,
I have reinstalled a test server after a disk crash. I upgraded from an older
Fedora Core (don't
remember the version) to Fedora Core 21.
Then I installed Mysql 5.7.7 from RPM. I'm able to start it but mysql does not
use my /etc/my.cnf
file and I do not find any other on my system.
It seems that your new MySQL doesn't have some of the required mysql system
database tables, most of them are handled by InnoDB, e.g.:
*May 15 09:41:27 anakin mysqld: 2015-05-15T07:41:27.595846Z 0 [Warning]
InnoDB: Cannot open table
mysql/plugin from the internal data dictionary of InnoDB though
Hi,
If I execute service myqsld start its saying
mysqld: unrecognized service
-Original Message-
From: Reindl Harald [mailto:h.rei...@thelounge.net]
Sent: Thursday, April 05, 2012 4:05 PM
To: mysql@lists.mysql.com
Subject: Re: Error in starting MySQL
boah do not top-post!
this was a typo - seems you did not understand my question
WHY are you downloading random binaries instead using
packages from your linux distribution which are tested
and preconfigured?
Am 05.04.2012 12:39, schrieb Manivannan S.:
Hi,
If I execute service myqsld
Am 05.04.2012 12:27, schrieb Manivannan S.:
Hi,
In 64-bit Linux(Centos/Red Hat) machine when I am trying to
start the MySQL service by using service mysql start command , I am getting
the following error
I have installed
MySQL-client-5.1.52-1.glibc23.x86_64.rpm
Hi,
In 64-bit Linux(Centos/Red Hat) machine when I am trying to
start the MySQL service by using service mysql start command , I am getting the
following error
Ø Starting MySQL.Manager of pid-file quit without updating file [FAILED]
If I try to stop the MySQL service I am
@lists.mysql.com
Subject: Re: Error in starting MySQL service on LINUX
boah do not top-post!
this was a typo - seems you did not understand my question WHY are you
downloading random binaries instead using packages from your linux distribution
which are tested and preconfigured?
Am 05.04.2012 12
-
From: lists-mysql [mailto:replies-lists-b3z1-my...@listmail.innovate.net]
Sent: Thursday, April 05, 2012 5:28 PM
To: Manivannan S.
Subject: RE: Error in starting MySQL service on LINUX
Original Message
Date: Thursday, April 05, 2012 11:04:48 AM +
From
: RE: Error in starting MySQL service on LINUX
Original Message
Date: Thursday, April 05, 2012 11:04:48 AM +
From: Manivannan S. manivanna...@spanservices.com
To: mysql@lists.mysql.com
Subject: RE: Error in starting MySQL service on LINUX
I am not using
in starting MySQL service on LINUX
Original Message
Date: Thursday, April 05, 2012 11:04:48 AM +
From: Manivannan S. manivanna...@spanservices.com
To: mysql@lists.mysql.com
Subject: RE: Error in starting MySQL service on LINUX
I am not using
How do I start MySQL in maintenance/single user mode so I can create
indexes on a table that is being updated often?
I prefer for the update transactions to fail immediately with a
connection error rather than to wait for a lock to be released.
In Oracle you can startup nomount. What is the
Subject: Starting MySQL in Maintenance mode
How do I start MySQL in maintenance/single user mode so I can create
indexes on a table that is being updated often?
I prefer for the update transactions to fail immediately with a
connection error rather than to wait for a lock to be released
...@logicworks.net]
Sent: Wednesday, May 20, 2009 4:13 PM
To: TETTERTON George; mysql@lists.mysql.com
Subject: RE: Starting MySQL in Maintenance mode
Do 'service mysql restart --skip-networking'
This prevents all TCP/IP connections
You can login as r...@localhost and the client program will use the
socket file
Hi, I constantly keep receiving this kind of error:
mariuszlenks-ibook-g4:~ mariuszlenk$ cd /usr/local/mysql
mariuszlenks-ibook-g4:/usr/local/mysql mariuszlenk$ sudo ./bin/mysqld_safe
Password:
./bin/mysqld_safe: line 1: ./bin/my_print_defaults: cannot execute binary file
./bin/mysqld_safe: line
Hi,
I'm having a hard time starting MySQL 4.1.21
I get:
Starting mysqld daemon with databases from /usr/local/mysql-4.1.21/var
STOPPING server from pid file /tmp/mysql.pid
061102 14:06:13 mysqld ended
In the logs, i have:
061102 14:07:25 mysqld started
InnoDB: Error: auto-extending data file
I have a very simple question about starting mysql. I start manually the
server under the unix account mysql with the following:
/seqweb/mysql4/bin/mysqld_safe --user=mysql
in order to get the unix user mysql to run the process.
I get the following with ps -ef | grep mysql:
mysql 29527
tuxlinsecure wrote:
Hi,
What binaries directory premissions are required to enable in sudo to start mysql Instance through sudo.
Thanks,
-
How low will we go? Check out Yahoo! Messenger’s low PC-to-Phone call rates.
You should ask on a sudo / Unix
tuxlinsecure wrote:
Hi,
What binaries directory premissions are required to enable in sudo to start
mysql Instance through sudo.
Thanks,
Hi All,
what user do you want to be able to start MySQL? Just add that
user to your wheel group(be careful though, as that gives that user full
power
Hi,
What binaries directory premissions are required to enable in sudo to start
mysql Instance through sudo.
Thanks,
-
How low will we go? Check out Yahoo! Messengers low PC-to-Phone call rates.
Hi folks,
I have MySQL 5.0.18 running like a charm on Win2K as a service. I've
been connecting to it willy-nilly, creating databases and querying the
daylights out of it. Working just dandy.
I'm trying to run the MySQL monitor in a DOS box and having no luck. I
open a DOS box, and no matter
I'm trying to run the MySQL monitor in a DOS box and having no luck. I
open a DOS box, and no matter what command I run, I do not get the nifty
mysql prompt that I can get on my Linux machine. Here are some
permutations and the results (or lack thereof):
c:\mysql\bin mysql -u root -p
mysql:
Anyone have any ideas on this one?
Many thanks.
RobL
On Friday 10 February 2006 15:07, Rob Lacey wrote:
Running as root.
RobL
On Friday 10 February 2006 14:55, sheeri kritzer wrote:
Are you running the startup script as root, or is it setuid?
-Sheeri
On 2/10/06, Rob Lacey [EMAIL
Wondering if anyone can shed some light on a problem I am experiencing.
I am running MySQL 4.1 on a Red Hat Enterprise Linux ES release 4 (Nahant
Update 2) machine.
I have been trying to get the default /etc/init.d/mysqld script to restart the
server but I keep running into the same problems.
Are you running the startup script as root, or is it setuid?
-Sheeri
On 2/10/06, Rob Lacey [EMAIL PROTECTED] wrote:
Wondering if anyone can shed some light on a problem I am experiencing.
I am running MySQL 4.1 on a Red Hat Enterprise Linux ES release 4 (Nahant
Update 2) machine.
I have
Running as root.
RobL
On Friday 10 February 2006 14:55, sheeri kritzer wrote:
Are you running the startup script as root, or is it setuid?
-Sheeri
On 2/10/06, Rob Lacey [EMAIL PROTECTED] wrote:
Wondering if anyone can shed some light on a problem I am experiencing.
I am running MySQL
Hi All
New to MySQL in that I have never ran a database.
I have Mandrake 10.1 in which I can not connect to because I do not have the
correct MySQL connector but MySQL server is working. Having spent over a week
looking for the correct connector twice -last August and last week - I am
well
SOTL [EMAIL PROTECTED] wrote on 12/24/2005 06:22:25 PM:
Hi All
New to MySQL in that I have never ran a database.
I have Mandrake 10.1 in which I can not connect to because I do not have
the
correct MySQL connector but MySQL server is working. Having spent over a
week
looking for the
Hello.
Start points for you problem:
http://dev.mysql.com/doc/refman/5.0/en/can-not-connect-to-server.html
http://dev.mysql.com/doc/refman/5.0/en/starting-server.html
socket=/home.dbdata/mysql/mysql.sock
What is your client thinks about the location of mysqld socket?
Put the same
Hi all
First usage of MySQL. Newbie in Linux as well as MySQL. Using CentOS 4.2
with MySQL 4.1.12, rpm install.
Changed the data directory.
My /etc/my.conf
---
[mysqld]
datadir=/home.dbdata/mysql
socket=/home.dbdata/mysql/mysql.sock
# Default to using old password format for
Hi all
First usage of MySQL. Newbie in Linux as well as MySQL. Using CentOS 4.2
with MySQL 4.1.12, rpm install.
Changed the data directory.
My /etc/my.conf
[mysqld]
datadir=/home.dbdata/mysql
socket=/home.dbdata/mysql/mysql.sock
# Default to using old password format for compatibility with
starting MySQL..changed Data Directory
Hi all
First usage of MySQL. Newbie in Linux as well as MySQL. Using CentOS 4.2
with MySQL 4.1.12, rpm install.
Changed the data directory.
My /etc/my.conf
[mysqld]
datadir=/home.dbdata/mysql
socket=/home.dbdata/mysql/mysql.sock
# Default to using old password
I have installed the following rpm's for mysql on my node
[EMAIL PROTECTED] mysql]# rpm -qa | grep -i mysql
MySQL-client-standard-5.0.15-0.rhel4
MySQL-server-standard-5.0.15-0.rhel4
MySQL-shared-standard-5.0.15-0.rhel4
MySQL-devel-standard-5.0.15-0.rhel4
The node is:
[EMAIL PROTECTED] mysql]#
Connie,
The port you have specified (1020) requires root permissions as does any
port 1024 and below. The normal port is 3306. I'm suspecting that your
mysql server installation is configured to run as mysql or some user
other than root. Change the port to something above 1024 and you
Hello.
and restarted MySQL with /etc/init.d/mysql start, I get the following:
Starting MySQL database server: mysqld.
Checking for crashed MySQL tables in the background.
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: '[EMAIL PROTECTED
on the re-done system, it worked. When altered the line
in /etc/mysql/my.cnf from:
datadir = /var/lib/mysql
to:
datadir = /thresh/tNet/db
and restarted MySQL with /etc/init.d/mysql start, I get the following:
Starting MySQL database server: mysqld.
Checking for crashed MySQL tables
I am new to MySQL and was recently given a task where I need to
transfer a database from one computer to another. Both computers are
Macintoshes running OS X Panther. Both computers are running MySQL
through localhost. The computer to which I am transferring the
database has MySQL up and running
Darryl Reeves [EMAIL PROTECTED] writes:
I am new to MySQL and was recently given a task where I need to
transfer a database from one computer to another. Both computers are
Macintoshes running OS X Panther. Both computers are running MySQL
through localhost. The computer to which I am
I'm starting to play with linux. Till now I have over my shoulders three
days experience with it :-)
I have been able to install and successfully run mysql 4.1.12 but
something it's happening I cannot understand (no surprise)
With my sql stopped I go to console as root and write:
cd
Juan Pedro Reyes Molina wrote:
With my sql stopped I go to console as root and write:
cd /etc/init.d
mysql start
At this point, try (as root)
which mysql
It will certainly not be /etc/init.d/mysql, but somewhere in your
defined PATH; try
echo $PATH
to see what that is
I would like to
hello, Hassan
which mysql gives me /usr/bin/mysql. echo $PATH shows me that /usr/bin
is the fourth try. I thougth this was windows like, where PATH is only
used if program is not found in active directory.
So, I have a script in /etc/init.d called mysql and an executable in
/usr/bin also
Juan Pedro Reyes Molina wrote:
which mysql gives me /usr/bin/mysql. echo $PATH shows me that /usr/bin
is the fourth try. I thougth this was windows like, where PATH is only
used if program is not found in active directory.
Executables in the 'current working directory' will only be used
if
- Original Message -
From: Juan Pedro Reyes Molina [EMAIL PROTECTED]
To: Hassan Schroeder [EMAIL PROTECTED]
Cc: mysql general list mysql@lists.mysql.com
Sent: Saturday, June 25, 2005 2:08 PM
Subject: Re: starting mysql 4.1.12 on Ubuntu Linux
hello, Hassan
which mysql gives me /usr
Where do I look for log file?
I have read mysql log file and see no indication of start up with
linux, last entry is about prior shutdown. (BTW every time mysql starts
it writes on err file: /usr/sbin/mysqld-max: File
'/var/log/mysql/mysql.log' not found (Errcode: 13) but directory
:
- Original Message - From: Juan Pedro Reyes Molina
[EMAIL PROTECTED]
To: Hassan Schroeder [EMAIL PROTECTED]
Cc: mysql general list mysql@lists.mysql.com
Sent: Saturday, June 25, 2005 2:08 PM
Subject: Re: starting mysql 4.1.12 on Ubuntu Linux
hello, Hassan
which mysql gives me /usr/bin/mysql
In the process I noticed somehow someone had managed to install a
slightly different version of mysql vs. mysql-max, so I uninstalled
everything msyql related and started over, came right up with InnoDB
support!
-
Kevin Korngut
Mr. Magoo
JANIMATION INC.
www.janimation.com
I'm attempting to configure mysql with InnoDB tables and I'm running
into problems. And am using the following version of mysqld-max, Ver
4.0.18-Max for suse-linux on i686 (Source distribution)
First I uncommented the following lines in /etc/my.cnf:
# Uncomment the following if you are using
[EMAIL PROTECTED], mysql@lists.mysql.com
Subject
Re: Difficulty starting mysql
errno 13 is permission denied. It looks like mysql doesn't have
permission to access your grant tables.
-Eric
On Wed, 23 Feb 2005 14:00:58 -0600, John Trammell [EMAIL PROTECTED]
wrote:
Did you follow
Hello,
I'm attempting to start mysql 4.1.10 compiled source code on Red Hat
Advanced Server 2.1 with apache 2.0.49. ./configure, make and make
install went successfully. But when I attempt to start mysql using this
command:
sudo mysqld_safe --user=mysql
I get the following errors:
Starting
Did you follow the procedure in
http://dev.mysql.com/doc/mysql/en/quick-install.html
?
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 23, 2005 1:29 PM
To: mysql@lists.mysql.com
Subject: Difficulty starting mysql
Hello,
I'm
?
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 23, 2005 1:29 PM
To: mysql@lists.mysql.com
Subject: Difficulty starting mysql
Hello,
I'm attempting to start mysql 4.1.10 compiled source code
on Red Hat
Advanced Server 2.1 with apache
Hello Mukund,
Remove the /etc/my.cnf file and start the mysqld daemon again. It will
work
Thanks,
Mathan
- Original Message -
From: Mukund N Rathi [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, November 26, 2004 11:31 AM
Subject: Socket Error While Starting MySQL
Hi All
Hi All,
I am facing some problems with installation of MySQL on Mac.
I have installed MySQL on mac 10.3.5. but now whenever I try to run and
start MySQL,
it gives me following error
ERROR 2002 (HY000): Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (2)
I went to the
MySQL 4.0.14
InnoDB (File size as it stands at present) = 6 GB
We have tried move the data folder from one hard disk
to another still the same problem. We really are in
need of help here. Is there any size limit in InnoDB?
I did ask this before, I did get some reponse thank
you. But due to
Hi!
The size limit in InnoDB is 64 TB.
You have probably mixed up ibdata files or ib_logfiles. The ib_logfiles that
you are using are probably completely zero-filled. No checkpoint info in
them.
What does
mysqld-nt --console
print if you move the ib_logfiles away?
When creating new ibdata
Hello,
I have installed mysql but did not install it as a service.
All I do is runmysqld-max-nt.exe
Now I need it to run as a service. It is on a win2003 machine.
Can I make it run as a service once I already have it installed.
I cannot lose data and do not want to do a mysqldump, uninstall
On 22 Nov 2004 at 9:34, James Sherwood wrote:
Hello,
I have installed mysql but did not install it as a service.
All I do is runmysqld-max-nt.exe
Now I need it to run as a service. It is on a win2003 machine.
Can I make it run as a service once I already have it installed.
I
Hello.
You may specify location of temp files with 'tmpdir' server system variable.
See:
http://dev.mysql.com/doc/mysql/en/Temporary_files.html
http://dev.mysql.com/doc/mysql/en/Server_system_variables.html
Gail Lange [EMAIL PROTECTED] wrote:
Hello
I have just installed mysql
Hello
I have just installed mysql 4.1.7 on Mandrake 10.0 (final).
All went smoothly.
However, when I issue the following command:
/usr/local/mysql/bin/mysqld_safe --user=mysql
I get the error:
Can't create/write to file /root/tmp/ibLmfg7w (Errcode: 13)
Hello
I have just installed mysql 4.1.7 on Mandrake 10.0 (final).
All went smoothly.
However, when I issue the following command:
/usr/local/mysql/bin/mysqld_safe --user=mysql
I get the error:
Can't create/write to file /root/tmp/ibLmfg7w (Errcode: 13)
When
PROTECTED]
Subject: error starting mysql 4.1.7 cannot create/write to /root/tmp
Hello
I have just installed mysql 4.1.7 on Mandrake 10.0 (final).
All went smoothly.
However, when I issue the following command:
/usr/local/mysql/bin/mysqld_safe --user=mysql
I get
Jason Williard [EMAIL PROTECTED] wrote:
I have a new linux server that I just installed the
mysql-max-4.0.21-pc-linux-i686 binary on. The installation had no errors.
However, it is not starting on startup because of the following error:
Can't execute ./bin/mysqld_safe from dir /var/lib
I have a new linux server that I just installed the
mysql-max-4.0.21-pc-linux-i686 binary on. The installation had no errors.
However, it is not starting on startup because of the following error:
Can't execute ./bin/mysqld_safe from dir /var/lib
I can start MySQL manually running
Hi all,
I have a customer for which, on one of his server running Red Hat 7, when
it starts mysql, mysqld take all the CPU ressources. He can connect on the
command line and do basic things like show tables, but he has a PHP
application can no longer connect to the data base.
I will be visiting
Hello all,
I have installed mysql and in one of the tutorials it has told me to do
the following:
You can start the MySQL server with the following command:
shell ./bin/mysqld_safe --user=mysql
However when I did this I got the following:
/mysqld_safe --user=mysql
Thanks,
Mathan
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Thursday, June 17, 2004 3:17 PM
Subject: starting mysql server
Hello all,
I have installed mysql and in one of the tutorials it has told me to do
PROTECTED]
Sent: Thursday, June 17, 2004 12:47 PM
Subject: starting mysql server
Hello all,
I have installed mysql and in one of the tutorials it has told me to do
the following:
You can start the MySQL server with the following command:
shell ./bin/mysqld_safe --user=mysql
However when
hello,
I have installed mysql-3.23.58-pc-linux-i686 on Red Hat 9.0,
while starting daemon i got the following message:
./bin/safe_mysqld --user=mysql
[1] 5240
[EMAIL PROTECTED] mysql-3.23.58-pc-linux-i686]# Starting mysqld daemon with
databases from /usr/local/mysql-3.23.58-pc-linux-i686/data
Rohan Shrivastava [EMAIL PROTECTED] wrote:
hello,
I have installed mysql-3.23.58-pc-linux-i686 on Red Hat 9.0,
while starting daemon i got the following message:
./bin/safe_mysqld --user=mysql
[1] 5240
[EMAIL PROTECTED] mysql-3.23.58-pc-linux-i686]# Starting mysqld daemon with
Friday, April 09, 2004, 8:59:48 PM, Rohan Shrivastava wrote:
RS there are some tables named
RS columns_priv and tables_priv
RS are you talking about these
Yes.
In this case check permissions on the MySQL data dir and files.
MySQL should be owner of the data dir.
RS Regards
RS Rohan
Rohan
: starting mysql daemon
Try this one:
Copy share/mysql/my-medium.cnf file to /etc/my.cnf and run
mysql_install_db and chown -R mysql mysql data dir and mysqld_safe
command.
Find the mysql datadir from mysql_install_db file (line no 77 : e.g.
ldata=/var/opt/mysql)
Thanks,
Mathan
hi
**(plz someone help me urgently)**
i have tried the procedure mentioned below but of no avail.
this is the exact message in .err file
can not start server : bind on unix socket : permission denied
do you have another mysql server running on socket /var/run/mysql/mysql.sock ?
As root, you start the mysql server. The first thing the server does is
switch to running as the mysql user, then it tries to bind the socket. Most
likely, your problem is that the mysql user does not have permission to
write the socket file in /var/run/mysql. As root, run `chown mysql:mysql
/mysql.sock ?
/usr/libexec/mysqld : shutdown complete
mysqld ended
--- i am trying to run the server as root
--- there is no such file as /var/run/mysql/mysql.sock
now what to do
regards
alqama
Hi!
a few things to try:
1.- you should never start the server as root, instead try starting
mysql
regards
alqama
Hi!
a few things to try:
1.- you should never start the server as root, instead try starting
mysql as mysql user
2.- do you have write permission under /var/run/mysql?
Best Regards
hello
a few days ago i had this problem in starting mysql daemon.. (described below by
previous messages).. which was solved.
i changed the permissions of the data directory.
but now again i am facing the same problem.
but the error message is of binding the unix socket.
something like
: muhammad alqama [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, April 01, 2004 9:19 PM
Subject: Re: starting mysql daemon
hi
the error mentioned in the file is...
fatal error : can not open privilege tables can not
find file : './mysql/host.frm' (errno 13
muhammad alqama [EMAIL PROTECTED] wrote:
hello
a few days ago i had this problem in starting mysql daemon.. (described below by
previous messages).. which was solved.
i changed the permissions of the data directory.
but now again i am facing the same problem.
but the error message
To: muhammad alqama [EMAIL PROTECTED]
Subject: Re: starting mysql daemon
This file is normally located in the data directory
On Wed, 31 Mar 2004, you wrote:
hi
can u tell me where this file hostname.err lies
as i have searched and not found it .
- Original Message
PROTECTED]
Subject: Re: starting mysql daemon
hi
the error mentioned in the file is...
fatal error : can not open privilege tables can not
find file : './mysql/host.frm' (errno 13)
what to do now...
regards
alqama
- Original Message -
From: Victor Pendleton [EMAIL
- Original Message -
From: Victor Pendleton [EMAIL PROTECTED]
Date: Wed, 31 Mar 2004 16:03:43 -0600
To: muhammad alqama [EMAIL PROTECTED]
Subject: Re: starting mysql daemon
This file is normally located in the data directory
On Wed, 31 Mar 2004, you wrote
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: starting mysql daemon
hi
the error mentioned in the file is...
fatal error : can not open privilege tables can
not
find file : './mysql/host.frm' (errno 13)
what to do now...
regards
alqama
-
From: [EMAIL PROTECTED]
Date: Thu, 1 Apr 2004 10:02:22 -0600
To: [EMAIL PROTECTED],
[EMAIL PROTECTED],[EMAIL PROTECTED]
Subject: RE: starting mysql daemon
Errno 13 indicates a permissions error. Please
check the ownership of the
data directories you're using to make sure that
the mysql
hello
it is now running ..
thank everyone who helped me ... many many thanks
regards
alqama
- Original Message -
From: Michael Stassen [EMAIL PROTECTED]
Date: Thu, 01 Apr 2004 12:13:43 -0500
To: muhammad alqama [EMAIL PROTECTED]
Subject: Re: starting mysql daemon
- Original Message -
From: muhammad alqama [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, April 01, 2004 10:49 PM
Subject: Re: starting mysql daemon
hi
the error mentioned in the file is...
fatal error : can not open privilege tables can not
find file
hello
i am using slackware linux and i installed mysql
server with the installation.
now i am trying to start the mysql daemon but it is
not being start.
i have run mysql_install_db --user=mysql .. it
runs successfully. but as i run the command
mysqld_safe to run daemon it gives the
Did you check in the hostname.err file to see why MySQL ended?
On Wed, 31 Mar 2004, muhammad alqama wrote:
hello
i am using slackware linux and i installed mysql
server with the installation.
now i am trying to start the mysql daemon but it is
not being start.
i have run
- Original Message -
From: Victor Pendleton [EMAIL PROTECTED]
Date: Wed, 31 Mar 2004 15:17:54 -0600
To: muhammad alqama [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: Re: starting mysql daemon
Did you check in the hostname.err file to see why MySQL ended?
On Wed, 31 Mar 2004
I just downloaded and installed mysql 4.1.1 on a Macintosh G5, but I
cannot get it to start up. I first tried manual startup using the unix
commands as detailed in the manual. I kept getting the message mysql
shutting down before I could hit ctl-Z. Then when I tried to connect,
it stated:
I assume when you tried to start MySQL from the command line you used
safe_mysqld. You may not be seeing the error messages that would tell
you why it's not starting. Try starting mysql directly.
cd /usr/local/mysql
sudo ./bin/mysqld
You'll probably see an error message that is a bit more
Marty Ray wrote:
I just downloaded and installed mysql 4.1.1 on a Macintosh G5, but I
cannot get it to start up. I first tried manual startup using the unix
commands as detailed in the manual. I kept getting the message mysql
shutting down before I could hit ctl-Z. Then when I tried to
the error messages that would tell
you why it's not starting. Try starting mysql directly.
cd /usr/local/mysql
sudo ./bin/mysqld
You'll probably see an error message that is a bit more helpful.
On Feb 12, 2004, at 4:09 PM, Marty Ray wrote:
I just downloaded and installed mysql 4.1.1 on a Macintosh G5
Marty Ray
This should help you out - http://www.entropy.ch/software/macosx/mysql/
I just downloaded and installed mysql 4.1.1 on a Macintosh G5, but I
cannot get it to start up. I first tried manual startup using the unix
commands as detailed in the manual. I kept getting the message mysql
Okay, I tried all of that and I still couldn't connect.
Here is what I got from the .err file:
040212 15:54:38 mysqld started
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
040212 15:54:38 InnoDB: Setting file ./ibdata1 size to 10 MB
You have to re-run the ./scripts/mysql_install_db
I had this exact error and it comes from deleting (or not installing) the
'mysql' database, which is a required component for MySQL to run. It also
installs a db called 'test' which is not required.
J.R. Bullington
Innovatim Technical Support
I really appreciate all the help! I tried running
./scripts/mysql_install_db and this is what I got:
G5-Computer:/usr/local/mysql martyray$ ./scripts/mysql_install_db
mkdir: ./data/mysql: Permission denied
chmod: ./data/mysql: Permission denied
mkdir: ./data/test: Permission denied
chmod:
K. Here are the step-by-step instructions that might help.
1 - Download and unpack the tar.gz file from mysql.com/downloads
2 - Open the Users panel and add a new user called 'mysql' with whatever
password you choose.
3 - Open Terminal.app and log on as root
4 - [/] root# cd /usr/local/mysql (or
Okay! Thank you all for the help!
'j.e.b.' suggested looking at the help info at the link below. That did
the trick. I was able to go through that info an troubleshoot my
problem.
You folks are great. A lot of experts are less than tolerant of
beginners. I feel welcome here and I appreciate
Michael Satterwhite [EMAIL PROTECTED] wrote:
I've reinstalled MySQL 4.1. I'm trying to start the server (mysqld_safe), but
it fails to start. The log file shows the message:
/usr/sbin/mysqld-max: Fatal error: Can't find messagefile
'/share/mysql/english/errmsg.sys'
The files exists, but
1 - 100 of 219 matches
Mail list logo
