On Mon, Nov 12, 2012 at 1:47 PM, Tianyin Xu wrote:
> Hi, Larry,
>
> Thanks a lot for the reply!
>
>
> On Mon, Nov 12, 2012 at 1:27 PM, Larry Martell wrote:
>
>> On Mon, Nov 12, 2012 at 2:11 PM, Tianyin Xu wrote:
>> > Hi, guys,
>> >
>> > I'm new to MySQL. I installed MySQL step-by-step according
Hi, Larry,
Thanks a lot for the reply!
On Mon, Nov 12, 2012 at 1:27 PM, Larry Martell wrote:
> On Mon, Nov 12, 2012 at 2:11 PM, Tianyin Xu 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.
>
On Mon, Nov 12, 2012 at 2:11 PM, Tianyin Xu 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 with the fo
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 problems
On Wed, Feb 29, 2012 at 2:20 PM, Elim Qiu 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] Setting lower_cas
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 wrote:
> I created (or activated) the root account and now I see the erro
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 /usr/local/mysql/data
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 wrote:
>
>
> Am 29.02.2012 19:20, schrieb Larry Martell:
>> Is the sudo succeeding? If it is, then there's no reason you shouldn't
>> be
On Wed, Feb 29, 2012 at 11:00 AM, Elim Qiu 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 09:01 bin
> drwxr-
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 wrote:
> -rw-r--r-- 1 root wheel 17987 Dec 17 09:01 COPYI
-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
On Wed, Feb 29, 2012 at 10:17 AM, Elim Qiu 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
> wrote:
>>
>> On Wed, Feb 29, 2012 at 7:46 AM, Elim Qiu wrote
Thanks Larry and Darryle for your help
Where the error log should be?
On Wed, Feb 29, 2012 at 8:22 AM, Larry Martell wrote:
> On Wed, Feb 29, 2012 at 7:46 AM, Elim Qiu wrote:
> > Yes, there is an icon. I can open the preference but the start service
> > button cannot do the job
>
> What is in t
On Wed, Feb 29, 2012 at 7:46 AM, Elim Qiu 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
> wrote:
>
>> Do you see a MySql icon under System Prefer
I have version 5.5.17 MySQL Community Server (GPL) on my Mac.
On Wed, Feb 29, 2012 at 9:36 AM, Elim Qiu 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 wrote:
>
>> *I down
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
wrote:
> Do you see a MySql icon under System Preferences > Other ? That's how
> I start MySql on my Mac.
>
> **
>
>
>
>
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 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) s
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 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) started apac
*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.*
**
On Mon, Jan 16, 2012 at 4:37 AM, mantianyu 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 --user=mysql
>
>
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 sh
;mantianyu"
> 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
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 '/var/ru
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
"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.
> >
&g
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. "MySQ
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)
or tried to start the service from the Windows management console
(Services), the following error app
t 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.
>
> When I try to:
>
> net start mys
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
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 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 Paha
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 performe
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.
Inn
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 Maili
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:
Inno
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
Mouse
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 re
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 sta
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
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'.
l
-->Subject: Cannot start MySQL (errno 13)
-->
-->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 i
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
;Organization:
>MySQL support: [none X| licence | email support | extended email support ]
>Synopsis: cannot start server after replacing data directory files
>Severity:
>Priority:
>Category: mysql
>Class:
>Release: mysql-3.23.53-entropy.ch (ht
magnus,
Monday, April 15, 2002, 9:04:10 PM, you wrote:
mll>Description:
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 dire
>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 (/proj/we
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:\mysql>cd\mysql\bin
C:\mysql\bin>mysqladmin 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_mys
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"
Hi.
I am running Windows 98 and have installed MySQL 3.23.47 under
D:\Program Files\MySQL\. I created C:\my.cnf and it contains the
following:
[mysqld]
skip-innodb
basedir=D:/Program Files/MySQL/
datadir=E:/mysql/
When I start mysqld, I get the following in the error file:
D:\Program Files\MyS
>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
IL PROTECTED]>
>> wrote:
>>
>>>
>>> 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
D]>
wrote:
>
> 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
>
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
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: No
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", 0xe0
>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
pos
>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
post
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)
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
> mysql-3
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 co
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 .index or .nnn files anywhere. Do you
64 matches
Mail list logo