Hi, guys,
I'm new to MySQL. I installed MySQL step-by-step according to the manual
from source code. The version is mysql-5.5.28.
When I start the server using:
#bin/mysqld_safe --user=mysql
The server failed to start with the following message in the log (attached
below).
There're two
On Mon, Nov 12, 2012 at 2:11 PM, Tianyin Xu t...@cs.ucsd.edu wrote:
Hi, guys,
I'm new to MySQL. I installed MySQL step-by-step according to the manual
from source code. The version is mysql-5.5.28.
When I start the server using:
#bin/mysqld_safe --user=mysql
The server failed to start
Hi, Larry,
Thanks a lot for the reply!
On Mon, Nov 12, 2012 at 1:27 PM, Larry Martell larry.mart...@gmail.comwrote:
On Mon, Nov 12, 2012 at 2:11 PM, Tianyin Xu t...@cs.ucsd.edu wrote:
Hi, guys,
I'm new to MySQL. I installed MySQL step-by-step according to the manual
from source code.
On Mon, Nov 12, 2012 at 1:47 PM, Tianyin Xu t...@cs.ucsd.edu wrote:
Hi, Larry,
Thanks a lot for the reply!
On Mon, Nov 12, 2012 at 1:27 PM, Larry Martell larry.mart...@gmail.comwrote:
On Mon, Nov 12, 2012 at 2:11 PM, Tianyin Xu t...@cs.ucsd.edu wrote:
Hi, guys,
I'm new to MySQL. I
*I downloaded **Mac OS X ver. 10.6 (x86, 64-bit), DMG Archive, installed to
my pretty clean os x 10.6.8 (snow leopard) after (1st time) started apache.
The installation went smoothly but the service just cannot be started.*
**
Do you see a MySql icon under System Preferences Other ? That's how
I start MySql on my Mac.
On Wed, Feb 29, 2012 at 9:05 AM, Elim Qiu elim@gmail.com wrote:
*I downloaded **Mac OS X ver. 10.6 (x86, 64-bit), DMG Archive, installed to
my pretty clean os x 10.6.8 (snow leopard) after (1st
The vertion of MySQL that I cannot start is 5.1.61 (the only one for 5.1*
mac at mysql.com)
On Wed, Feb 29, 2012 at 7:05 AM, Elim Qiu elim@gmail.com wrote:
*I downloaded **Mac OS X ver. 10.6 (x86, 64-bit), DMG Archive, installed
to my pretty clean os x 10.6.8 (snow leopard) after (1st time
Yes, there is an icon. I can open the preference but the start service
button cannot do the job
On Wed, Feb 29, 2012 at 7:20 AM, Darryle Steplight dstepli...@gmail.com
wrote:
Do you see a MySql icon under System Preferences Other ? That's how
I start MySql on my Mac.
**
I have version 5.5.17 MySQL Community Server (GPL) on my Mac.
On Wed, Feb 29, 2012 at 9:36 AM, Elim Qiu elim@gmail.com wrote:
The vertion of MySQL that I cannot start is 5.1.61 (the only one for 5.1*
mac at mysql.com)
On Wed, Feb 29, 2012 at 7:05 AM, Elim Qiu elim@gmail.com wrote
On Wed, Feb 29, 2012 at 7:46 AM, Elim Qiu elim@gmail.com wrote:
Yes, there is an icon. I can open the preference but the start service
button cannot do the job
What is in the mysql error log?
On Wed, Feb 29, 2012 at 7:20 AM, Darryle Steplight dstepli...@gmail.com
wrote:
Do you see a
Thanks Larry and Darryle for your help
Where the error log should be?
On Wed, Feb 29, 2012 at 8:22 AM, Larry Martell larry.mart...@gmail.comwrote:
On Wed, Feb 29, 2012 at 7:46 AM, Elim Qiu elim@gmail.com wrote:
Yes, there is an icon. I can open the preference but the start service
On Wed, Feb 29, 2012 at 10:17 AM, Elim Qiu elim@gmail.com wrote:
Thanks Larry and Darryle for your help
Where the error log should be?
http://dev.mysql.com/doc/refman/5.0/en/error-log.html
On Wed, Feb 29, 2012 at 8:22 AM, Larry Martell larry.mart...@gmail.com
wrote:
On Wed, Feb 29,
-rw-r--r-- 1 rootwheel 17987 Dec 17 09:01 COPYING
-rw-r--r-- 1 rootwheel 7371 Dec 17 09:01 INSTALL-BINARY
-rw-r--r-- 1 rootwheel 2552 Dec 17 09:01 README
drwxr-xr-x 46 rootwheel 1564 Dec 17 09:01 bin
drwxr-x--- 8 _mysql wheel272 Feb 29 10:36 data
drwxr-xr-x 4
Are you looking in /usr/local/mysql/data ? You should see a
username.err file. You might have to sudo to open the file just do
sudo tail -f FILENAME or sudo taill -f /path/to/filename/ .
On Wed, Feb 29, 2012 at 1:00 PM, Elim Qiu elim@gmail.com wrote:
-rw-r--r-- 1 root wheel 17987 Dec
On Wed, Feb 29, 2012 at 11:00 AM, Elim Qiu elim@gmail.com wrote:
-rw-r--r-- 1 root wheel 17987 Dec 17 09:01 COPYING
-rw-r--r-- 1 root wheel 7371 Dec 17 09:01 INSTALL-BINARY
-rw-r--r-- 1 root wheel 2552 Dec 17 09:01 README
drwxr-xr-x 46 root wheel 1564 Dec 17
If you are going to use su to officially switch to the root users
just make sure you do su - with the dash.
On Wed, Feb 29, 2012 at 2:10 PM, Reindl Harald h.rei...@thelounge.net wrote:
Am 29.02.2012 19:20, schrieb Larry Martell:
Is the sudo succeeding? If it is, then there's no reason you
I created (or activated) the root account and now I see the error log:
sh-3.2# cat miniMac.local.err
120229 10:36:09 mysqld_safe Starting mysqld daemon with databases from
/usr/local/mysql/data
120229 10:36:09 [Warning] Setting lower_case_table_names=2 because file
system for
Looks like 5.1.61 mac installer messed up the privilege setting...
But how to fix it? I remember the server account is mysql, not _mysql
What do you got? And how to fix it? Thanks
On Wed, Feb 29, 2012 at 2:20 PM, Elim Qiu elim@gmail.com wrote:
I created (or activated) the root account and
On Wed, Feb 29, 2012 at 2:20 PM, Elim Qiu elim@gmail.com wrote:
I created (or activated) the root account and now I see the error log:
sh-3.2# cat miniMac.local.err
120229 10:36:09 mysqld_safe Starting mysqld daemon with databases from
/usr/local/mysql/data
120229 10:36:09 [Warning]
To: mysql@lists.mysql.com
Sent: Monday, 16 January, 2012 12:37:07 PM
Subject: help! mysqld cannot start!
I have download the
Linux - Generic 2.6 (x86, 32-bit), Compressed TAR Archive
binary edition
and I installed it all followed the INSTALL_BINARY
but at last step I start
2012/01/16 19:37 +0800, mantianyu
but at last step I start the service by run
sudo bin/mysqld_safe --user=mysql
I got following error message
cifer@Pig:/usr/local/mysql$ 120116 19:15:28 mysqld_safe Logging to
'/var/log/mysql/error.log'.
Your means of starting does not show where the
On Mon, Jan 16, 2012 at 4:37 AM, mantianyu mantia...@gmail.com wrote:
I have download the
Linux - Generic 2.6 (x86, 32-bit), Compressed TAR Archive
binary edition
and I installed it all followed the INSTALL_BINARY
but at last step I start the service by run
sudo bin/mysqld_safe
I'm still having a problem starting MySQL.
I get the following message:
Unable to initialise database connection: Can't connect to local MySQL server
through socket '/var/run/mysqld/mysqld.sock'
I've check the /etc/mysql/my.cnf and the sock file is supposed to load in
'/var/run/mysqld.
Thanks
Jon Miller wrote:
I'm still having a problem starting MySQL.
I get the following message:
Unable to initialise database connection: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'
I've check the /etc/mysql/my.cnf and the sock file is supposed to load in
,
however, I cannot start MySQL 4.1 although I have stopped MySQL 5 first.
When I try to:
net start mysql
(where mysql is the name of MySQL 4.1 service)
or tried to start the service from the Windows management console
(Services), the following error appears:
Could not start the MySQL service on Local
From: Stephen Cook [EMAIL PROTECTED]
Subject: Re: Cannot start MySQL under Win2000
You must not install 5.0 over 4.1, put it somewhere else.
Also, instead of naming the service MySQL both times, call it
something else (i.e. MySQL41 and MySQL50). If you use the Windows
installer distribution
Octavian Rasnita [EMAIL PROTECTED] wrote on 12/02/2005 10:39:16 AM:
From: Stephen Cook [EMAIL PROTECTED]
Subject: Re: Cannot start MySQL under Win2000
You must not install 5.0 over 4.1, put it somewhere else.
Also, instead of naming the service MySQL both times, call it
something
Hi,
Is it possible to install 2 versions of MySQL on the same computer?
I want to have MySQL 4.1 and 5.0 installed, and use only one of them at a
time.
I have installed MySQL 5.0 over MySQL 4.1 and now MySQL 5 works fine,
however, I cannot start MySQL 4.1 although I have stopped MySQL 5 first
and 5.0 installed, and use only one of them at a
time.
I have installed MySQL 5.0 over MySQL 4.1 and now MySQL 5 works fine,
however, I cannot start MySQL 4.1 although I have stopped MySQL 5 first.
When I try to:
net start mysql
(where mysql is the name of MySQL 4.1 service
check if rpm creates mysql user and group.
then mysql_install_db, chown mysql:mysql /var/lib/mysql -R
and finally try starting mysqld again
t
050810 20:26:52 [ERROR] Fatal error: Can't open privilege tables: Table
'mysql.host' doesn't exist
050810 20:26:52 mysqld ended
--
MySQL General Mailing
Thanks for your reply. I confirmed that user and group, mysql, exists
and performed the chown as instructed but same thing. Here is my log
again after I did this:
050810 23:18:09 mysqld started
050810 23:18:09 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
Hello.
Check that mysql_install_db filled mysql database in the same directory
as your datadir. See:
http://dev.mysql.com/doc/mysql/en/unix-post-installation.html
Gobi [EMAIL PROTECTED] wrote:
Thanks for your reply. I confirmed that user and group, mysql, exists
and performed
I find that I can start mysqld by using the --skip-grant-tables option
but as soon as I run mysqld without that option, it dies again. I did
try running mysql_install_db --user=mysql but when I did mysqlshow
mysql, it was empty.
Any ideas on how to proceed?
Thanks,
Michael.
Gleb Paharenko
Never mind. I figured it out. I had to run the install_db script as
mysql user.
Gobi wrote:
I find that I can start mysqld by using the --skip-grant-tables
option but as soon as I run mysqld without that option, it dies
again. I did try running mysql_install_db --user=mysql but when I
I installed mysql from the following rpm packages:
mysql-4.1.10a-2.RHEL4.1
mysql-server-4.1.10a-2.RHEL4.1
I tried running 'mysqld start' and the server said startup failed. Here
is the mysq.log:
050810 20:26:48 mysqld started
InnoDB: The first specified data file ./ibdata1 did not exist:
Privet!
file: './mysql/host.frm' (errno: 13)
perror 13
OS error code 13: Permission denied
Change the owner of /var/lib/mysql to 'mysql' user. Please next time
post your messages to the list, the probability of helpful answers
increases in several times :)
On Tue, 31 May
Hello.
Are you sure that mysqld uses /etc/mysql/my.cnf? See:
http://dev.mysql.com/doc/mysql/en/option-files.html
I suggest you to use official binaries and perform installation
according to the following:
http://dev.mysql.com/doc/mysql/en/installing-binary.html
Nice time of the day.
I apologize I am writing on this address because didn't find START NEW THREAD
on mailing lists page.
The problem is this: I have the freshest version of Gentoo Linux, and mysql
within it. Just didn't modify /etc/mysql/my.cnf, commenting only one line:
skip-innodb.
Have
I have two servers, server5.mydomain.com and server8.mydomain.com. I want to
replicate one database on server5 to server 8.
I did the whole proceedure as recommended in
http://dev.mysql.com/doc/mysql/en/replication-howto.html - 6.4. How to Set
Up Replication
I setup the GRANT statement on server5
Chris Mason wrote:
I have two servers, server5.mydomain.com and server8.mydomain.com. I want to
replicate one database on server5 to server 8.
I did the whole proceedure as recommended in
http://dev.mysql.com/doc/mysql/en/replication-howto.html - 6.4. How to Set
Up Replication
I setup the GRANT
Hello Michael,
On Thursday 08 July 2004 23:58, Michael Johnson wrote:
I just tried installing 4.1.3 on my development machine today. To my
dismay, I couldn't get it to start properly. I was upgrading from 4.1.2,
which I installed identically to the procedure below.
On to the actual
I just tried installing 4.1.3 on my development machine today. To my
dismay, I couldn't get it to start properly. I was upgrading from 4.1.2,
which I installed identically to the procedure below.
On to the actual problem. When I started MySQL the first time I used
'/etc/init.d/mysql start'.
Hi all,
I have been working on getting MySQL going all day.
Initially I had it working but had problems with
mysqladmin. Figured that one out shutdown the server
and tried to restart but I now have an error. This is
what I found in my errorlog. In looking at the
documentation I think I have to do
Are you using symlinks?
- Dathan Vance Pattishall
- Sr. Programmer and mySQL DBA for FriendFinder Inc.
- http://friendfinder.com/go/p40688
---Original Message-
--From: Carol Andrejak [mailto:[EMAIL PROTECTED]
--Sent: Friday, October 10, 2003 1:04 PM
--To: mysql
--Subject: Cannot
support ]
Synopsis: cannot start server after replacing data directory files
Severity:
Priority:
Category: mysql
Class:
Release: mysql-3.23.53-entropy.ch (http://www.entropy.ch/software/macosx/mysql/)
Environment:
System: Darwin 127.0.0.1 6.2 Darwin Kernel
magnus,
Monday, April 15, 2002, 9:04:10 PM, you wrote:
mllDescription:
mll I installed the binary distribution (first time I am installing mysql
ever) for Solaris 8 in a non-standard location (/data/mysql/3.23.47/SunOS_5.8) which
is local on the server. I then
mll moved the data
Description:
I installed the binary distribution (first time I am installing mysql ever)
for Solaris 8 in a non-standard location (/data/mysql/3.23.47/SunOS_5.8) which is
local on the server. I then moved the data directory to a file server so it will be
part of daily backups
I just installed
MySQL-3.23/mysql-3.23.49-win.zip
from www.mysql.com Then opened it.
But I still could not run mysql..it looks like it could not find the server. Where is
the remote server?
Anyway, see below how I was struggling..
C:\mysqlcd\mysql\bin
C:\mysql\binmysqladmin ping
guo,
Tuesday, February 19, 2002, 1:49:50 AM, you wrote:
gl Dear Sir/Madam,
gl I install mysql on my computer but it did not work. after installing the
gl rpms, I use gnorpm to verify the installtion, and it's OK. but I couldn't
gl start my server, after I ran mysql_install_db and safe_mysqld
Dear Sir/Madam,
I install mysql on my computer but it did not work. after installing the
rpms, I use gnorpm to verify the installtion, and it's OK. but I couldn't
start my server, after I ran mysql_install_db and safe_mysqld
commands. I list the relevant information and I use the mysqlbug
Description:
How-To-Repeat:
Fix:
Submitter-Id: imamferianto
Originator:root
Organization: unsoed
MySQL support: none
Synopsis: cannot start mysqld
Severity: critical
Priority: high
Category: mysql
Class: sw-bug
Release: mysql
Hello.. Friends
I have just installed my OpenBSD 2.9 with mysql 3.23.37 and when i wanted to
startet i can do it first time, but if i have to restart the server. I
cannot start it again, why?
i come with this error.
w3# safe_mysqld
/usr/libexec/ld.so: my_print_defaults: libpthread.so.14.20
have just installed my OpenBSD 2.9 with mysql 3.23.37 and when i wanted
to startet i can do it first time, but if i have to restart the server. I
cannot start it again, why?
i come with this error.
w3# safe_mysqld
/usr/libexec/ld.so: my_print_defaults: libpthread.so.14.20: No such file
installed my OpenBSD 2.9 with mysql 3.23.37 and when i
wanted to startet i can do it first time, but if i have to restart the
server. I cannot start it again, why?
i come with this error.
w3# safe_mysqld
/usr/libexec/ld.so: my_print_defaults: libpthread.so.14.20: No such file
or directory
Description:
While starting mysqld, mysqld stops with default values from
support-files/my-medium.cnf.
I'm not sure if it's really a bug or just inadequate buffer settings. Anyway, you
asked
in the $hostname.err to make a bug report. ;-) My compile time flags you have in my
previous
Description:
While starting mysqld, mysqld stops with default values from
support-files/my-medium.cnf.
I'm not sure if it's really a bug or just inadequate buffer settings. Anyway, you
asked
in the $hostname.err to make a bug report. ;-) My compile time flags you have in my
previous
Hi,
some more notes:
when using strace to trace the startup, I see some strange errors:
read(198, test -z \$defaults\\n then\n..., 1024) = 1024
xstat(2, /usr/local/mysql/var/data/mysql, 0xe0a31d0) = -1 ENOENT (No such file or
directory)
xstat(2, ./share/mysql/english/errmsg.sys, 0xe0a31d0)
Hello.. Friends
I have just installed my OpenBSD 2.9 with mysql 3.23.37 and when i wanted to
startet i can do it first time, but if i have to restart the server. I
cannot start it again, why?
i come with this error.
w3# safe_mysqld
/usr/libexec/ld.so: my_print_defaults: libpthread.so.14.20
Hello.. Friends
I have just installed my OpenBSD 2.9 with mysql 3.23.37 and when i wanted to
startet i can do it first time, but if i have to restart the server. I
cannot start it again, why?
i come with this error.
w3# safe_mysqld
/usr/libexec/ld.so: my_print_defaults: libpthread.so.14.20
Hi all,
My RedHat 6.1 + MySQL 3.22.32 server box has some rare thing happens today.
This box is sitting on the 192 network. It allows a cgi program to run
select and update SQL statement, which triggered by the Internet.
This box was received a lot of query this afternoon. Suddenly, it(redhat)
Sir,
I have downloaded the binary stable version of
MySQL from the site www.mysql.com.The package I
downloaded is ..
mysql-3.23.37-pc-linux-gnu-i686.tar.gz
After unzipping and untaring,I entered then
directory
mysql-3.23.37-pc-linux-gnu-i686 and then i executed
the
./configure
On Wed, 25 Apr 2001, arijit das wrote:
Sir,
I have downloaded the binary stable version of
MySQL from the site www.mysql.com.The package I
downloaded is ..
mysql-3.23.37-pc-linux-gnu-i686.tar.gz
After unzipping and untaring,I entered then
directory
Hi. I have a 3.23.22 test db running on Linux 6.2. I am able to start the
database in log mode.
I also have a 3.23.28 production db running on Linux 6.2. When I start this
database in log mode, there is no indication that logging is running. There
are no log name.index or log name.nnn files
63 matches
Mail list logo