Have u executed mysql_install_db?
On 15-May-2015 1:31 pm, "Jørn Dahl-Stamnes" 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. I'm able to st
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 t
...@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
s
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
rather than TCP/IP.
Do all your DDL work.
When done, 'service mysql restart'
Rolando A. Edwards
MySQL DBA (CMDBA)
155 Avenue of the
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 u
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
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:
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 tr
:
- Original Message - From: "Juan Pedro Reyes Molina"
<[EMAIL PROTECTED]>
To: "Hassan Schroeder" <[EMAIL PROTECTED]>
Cc: "mysql general list"
Sent: Saturday, June 25, 2005 2:08 PM
Subject: Re: starting mysql 4.1.12 on Ubuntu Linux
hello, Hassan
which
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
/var
- Original Message -
From: "Juan Pedro Reyes Molina" <[EMAIL PROTECTED]>
To: "Hassan Schroeder" <[EMAIL PROTECTED]>
Cc: "mysql general list"
Sent: Saturday, June 25, 2005 2:08 PM
Subject: Re: starting mysql 4.1.12 on Ubuntu Linux
hello, H
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 yo
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 cal
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 lear
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.
Check your log file for details. Probably because of file permissions of
data folder.
Best Regards,
Cemal Dalar a.k.a Jimmy
System Administrator & Web Developer
http://www.gittigidiyor.com & http://www.dalar.net
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <
Check the owner and group for /home/mikem/local/mysql/data. It should be
mysql.
run the following commands
shell> groupadd mysql
shell> useradd -g mysql mysql
shell> chown -R mysql /home/mikem/local/mysql/data
shell> chgrp -R mysql /home/mikem/local/mysql/data
shell> ./bin
The user that mysql run as, has permission to write
in the /var/run/mysql dir?
Ronan
> muhammad alqama wrote:
> > 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 s
muhammad alqama wrote:
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
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
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 ?
/usr/lib
ot; <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>
Subject: Re: 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 " and "mysqld_safe"
> command.
> Fi
"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 mess
Message -
From: "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
qama
- Original Message -
From: "muhammad alqama" <[EMAIL PROTECTED]>
Date: Fri, 02 Apr 2004 00:45:27 +0800
To: [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: RE: starting mysql daemon
> hello
>
> the directory /var/lib/mysql/mysql (datadir) has
> read/write pe
- 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 err
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
--- Original Message -
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 usi
lto:[EMAIL PROTECTED]
> Sent: Thursday, April 01, 2004 9:46 AM
> 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
now...
regards
alqama
- 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 dat
]; [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
- Original Message -
F
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:
> > hi
> > can u tell me where this fi
- 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 ende
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
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 ex
Try setting the basedir=
parameter in your my.cnf file.
>> Original Message <<
On 2/4/04, 3:32:26 PM, Michael Satterwhite <[EMAIL PROTECTED]> wrote
regarding Starting MySQL 4.1:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
> I've reinstalled MySQL 4.1. I'm
Peter Moscatt <[EMAIL PROTECTED]> wrote:
> I have just installed 'MySQL-server' and
> 'MySQL-client' onto a Mandrake 9.1 system.
>
> The two RPMs installed without error and running mysql
> from the shell was fine and did what was expected of
> it.
>
> I have now rebooted the system and when I go
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Karam Chand wrote:
> Greetings
>
> I have MySQL 4.0.13 installed on WinXP machine. From
> the DOCS I read that support for SSL is provided with
> MySQL 4.x. The doc says that I need to install the
> library from openssl.org ( which I did ) and then
>
Thanks much, permissions. I did an rpm install of this package and it
appears some permissions were not or are not preserved by rpm. Well, live
and learn. I did the first step with chmod 0004 /var/lib/mysql, it's that
second one I'm not certain of. the user mysql exists and I gave it a
password
/var/lib/mysql must be world searchable:
/var/lib/mysql/ must be writeable by the user mysql.
/var/lib/mysql.sock will be created when mysqld starts, and must be
world writable.
jude dashiell wrote:
Here's the output I get only as a user to mysql but not logging in as
root:
Script started on Fri
Try:
safe_mysqld --user=user &
Bill
Jeremy Whitlock wrote:
MySQL List,
In Linux, I use:
[EMAIL PROTECTED] bin]$ safe_mysqld --user=user
to start the MySQL Server where user is a user in the database. When
this happens, the terminal that I start it in become unusable. Is this
by desi
On Fri, Feb 14, 2003 at 05:01:01PM +0200, Egor Egorov wrote:
> On Friday 14 February 2003 01:06, John Oliver wrote:
>
> > I removed the Red Hat MySQL RPMs (which worked fine, other than not
> > supporting InnoDB) and installed the 3.23.55-1 RPMs from mysql.com When
> > I try to start it:
> >
> >
On Friday 14 February 2003 01:06, John Oliver wrote:
> I removed the Red Hat MySQL RPMs (which worked fine, other than not
> supporting InnoDB) and installed the 3.23.55-1 RPMs from mysql.com When
> I try to start it:
>
> [joliver@joliver-lnx joliver]$ sudo /etc/rc.d/init.d/mysql start
> [joliver
On Fri, Feb 14, 2003 at 12:52:49AM +0100, Stefan Hinz wrote:
> Have you tried
> mysqld --console
> already? This will not solve your problem, but at least it will
> display quite some output to help you find the cause of the prob.
[joliver@joliver-lnx joliver]$ sudo /usr/sbin/mysqld --console
/us
John,
> [joliver@joliver-lnx joliver]$ sudo /etc/rc.d/init.d/mysql start
> [joliver@joliver-lnx joliver]$ Starting mysqld-max daemon with databases
> from /var/lib/mysql
> 030213 15:01:06 mysqld ended
Have you tried
mysqld --console
already? This will not solve your problem, but at least it wil
On Friday 10 January 2003 01:45, cam vong wrote:
> I'm currently using Red Hat 7.1. I have loaded the apache, php, and mysql
> rpm. I seem to be having trouble starting MySQL. It gives me the
> following error: Can not connect to localhost MySQL server through socket
> /var/lib/mysql/mysql.soc
Start the server.
cam vong wrote:
I'm currently using Red Hat 7.1. I have loaded the apache, php, and
mysql rpm. I seem to be having trouble starting MySQL. It gives me
the following error: Can not connect to localhost MySQL server
through socket /var/lib/mysql/mysql.sock (111). Can some
You should check the manual:
http://www.mysql.com/doc/en/Can_not_connect_to_server.html.
It shows the steps you can do to solve the problem.
On Thu, 2003-01-09 at 23:45, cam vong wrote:
> I'm currently using Red Hat 7.1. I have loaded the apache, php, and mysql
> rpm. I seem to be having trou
On Tuesday 24 December 2002 19:34, Andrew Schaefer wrote:
> I had the same problem. I fixed it by realizing that when the program was
> installed it put the mysql.sock file in the /var/libs/mysql dir however
> when it starts it looks for the file in /tmp You can either change the
> folder it loo
Make sure that your mysql daemon is running, if not, start it. Also, make
sure the mysql.sock file is present in /var/lib/mysql.
Bhavin.
- Original Message -
From: "Stick Dragon" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, November 10, 2002 3:44 PM
Subject: starting Mysql on
Make sure the service is started. If no, enter the command:
console> service mysql start
Adolfo
On Sun, 2002-11-10 at 16:44, Stick Dragon wrote:
i have installed redhat 8 and slackware linux and been trying to get mysql
to run. when i get to the console and type 'mysql' i get, error 20
Damien,
Thursday, October 03, 2002, 4:25:56 AM, you wrote:
DB> Hi, I have just started out using MySQL and have had no end of trouble
DB> getting it started. I am running Redhat 7.2 and MySQL 3.23. I found that I
DB> had to modify my.cnf to point to the path /var/lib/mysql/mysql instead of
D
Hi,
I'm also using RedHast 7.2 and yesterday when I tried to start the MySQL
server that came installed with the operating system I had no success.
This morning I downloaded MySQL-3.23.52-1.i386.rpm and
MySQL-client-3.23.52-1.i386.rpm and installed them then the server came
up without any probl
You can use the winmysqladmin tool located in the bin directory to install
it as a service.
(I'm not sure wether this also works on a '98SE machine)
CB
-Original Message-
From: Gerhard H. W. May [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 03, 2002 15:00
To: [EMAIL PROTECTED]
Subject
Joe:
Here is what we do ...
- Login as Administrator
- Open DOS Prompt, switch to the drive with MySQL on it, and CD\MYSQL\BIN
- Type MYSQLD-NT --INSTALL
- Type NET START MYSQL
If that doesn't do the trick, your C:\WINNT\MY.INI (or C:\MY.CNF) may not be
correct. Most coomon mistake is to use th
ensure that /tmp has correct read-write-execute permissions
-Original Message-
From: Hresko, Christian A. [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 13, 2002 10:57 AM
To: '[EMAIL PROTECTED]'
Subject: starting mysql
i'm moving MySQL over to unix and i can't for the life of me get
In the last episode (Jan 31), Eric Mayers said:
> How can I tell when the database is ready to go (preferably from a shell
> script)?
while ! mysqladmin status > /dev/null 2>&1 ; do sleep 10 ; done
--
Dan Nelson
[EMAIL PROTECTED]
Tried that , but I used the source to compile , and
put it into /usr/local/mysql
So every thing is diffrent. Haveing relied on YaST I
do not know how to do it manualy , where and what
files to edit. I came from the windows world an jumpt
on to linux back during suse 5.1 days. Tells you how
good
Use YaST to edit your configuration file. Scroll down to 'start_mysql',
and set it to 'yes'. Hit F10, and wait while it reconfigures things.
Enjoy.
Matthew Walker
Ecommerce Project Manager
Mountain Top Herbs
-Original Message-
From: Samy Elashmawy [mailto:[EMAIL PROTECTED]]
Sent: Monda
[mailto:[EMAIL PROTECTED]]
Sent: Monday, November 26, 2001 9:24 PM
To: Delbono Nicola; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: F/U @ Re: * reiteration re: (re)starting MySQL
I'd appreciate "note-by-note" directions. The "my.cnf" file wasn't to be
found on my
I believe MySQL to be an
>excellent database to learn by -- if indeed I can get the bugger actually
>going for me to learn by!
>
>
>
>Thanx to all for all assistance.
>
>
>
>:-) mhw (-:
>
>
>
>+++++
>
>
>
>At
;
>
>- Original Message -
>From: "gx-inc" <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Sent: Monday, November 26, 2001 5:31 PM
>Subject: * reiteration re: (re)starting MySQL
>
>
> >
> > * reiteration re: (re)starting MySQL
> &g
Just recently started seriously studying the "infernal trio" of Apache,
MySQL & PHP and got off to a decent start, but for reasons unknown can no
longer get MySQL to start up from the DOS prompt.
I keep getting a "Can't initialize InnoDB as innodb_data_file_path is not
set" message when I e
t: Wednesday, September 05, 2001 8:49 PM
Subject: Re: Starting MySQL-3.23.41-4mdk.src.rpm*
> Your message cannot be postsed to [EMAIL PROTECTED] because it
> contained an attachment. If you need to make a file publically available
> you should upload it to some public URL, and then paste the UR
That's what it's supposed to do. End the command with a "&" so it will
spawn into the background.
Scott
At 11:05 AM 6/18/2001 -0700, Dale Schell wrote:
>Hello all,
> I have mysql 3.23.39 installed on the new Mac OSX Server. The problem I
>am having is that when I start it from the command
I don't know if you have fixed this probelm, but I had the same problem on Red Hat
7.0. I had installed the rpm files from MySQL.com and RedHat.com. The problem was
solved by doing the following.
chmod 755 the "mysql" directory that contains the "mysql.sock" file.
I am currently running the l
bobit wrote:
>
> Hi - here's my prob and background info. Tried the fix - it didn't work.
>
> MySQL Connection Failed: Can't connect to local MySQL server through socket
>'/var/lib/mysql/mysql.sock' (111)
>
> Any thoughts...?
>
Is MySQL actually running on your system? Even if you installed
>How can i put mysql to start with my system, i´m worcking with RedHat Linux
RTFM: go to your sourcedir, cd Docs and read manual.txt.. or one of the
other manuals.. like the one at www.mysql.com
Bye,
B.
-
Before posting,
Please add /usr/local/mysql/bin in your PATH.
dwayne> I'm fairly new to MySQL and unix. I have installed mysql on redhat 6.2 without
too many problems. I am changing my o/s to FreeBSD 4.2 and have installed mysql after
many hours of grief. I have mysql set to start at boot time and this seems t
Carlos;
Carlos Corzo wrote:
> OK,
>
> I am just a bit confused still so I will try again. Do I need to stop mysql as it
> is running now before I start safe_mysql or will it just replace the current
> running version? Also, does it matter where I start it from? I can telnet to the
> server, e
Yes stop the old and start the new...on a side note...should have bought
DuBios's book...ISBN: 0-7357-0921-1 Found it to be an invaluable source on
this sort of stuff. In any event safe_mysqld seems to be default on most
sytems...Yes please get you security straight...if the app is colocated on
th
OK,
I am just a bit confused still so I will try again. Do I need to stop mysql as it
is running now before I start safe_mysql or will it just replace the current
running version? Also, does it matter where I start it from? I can telnet to the
server, execute the command and then move on.
As
72 matches
Mail list logo
