Re: [newbie] MySQL File Location

2005-03-24 Thread Mikkel L. Ellertson
SOTL wrote: Well I change the datadir in mysql-max and I have generated numerous versions of my.cnf directing MySQL to my desired directory each change causing MySQL refused to run. So I keep playing around with mysql-max and found that there is a second place where the config file does a test

Re: [newbie] MySQL File Location

2005-03-23 Thread Mikkel L. Ellertson
SOTL wrote: Hi All & Derek and Mikkel Thanks for the information. Derek sorry I did not mean to be insulting. I simply do not understand and am very happy for your help which I thank you very much for. I have checked I do not have a file called S90MySQL in any location. I especially checked th

Re: [newbie] MySQL File Location

2005-03-22 Thread SOTL
Hi All & Derek and Mikkel Thanks for the information. Derek sorry I did not mean to be insulting. I simply do not understand and am very happy for your help which I thank you very much for. I have checked I do not have a file called S90MySQL in any location. I especially checked that it doe

Re: [newbie] MySQL File Location

2005-03-21 Thread Mikkel L. Ellertson
Derek Jennings wrote: The packager who built the Mandrake package for MySQL has created the file /etc/rc5.d/S90mysql to set up the defaults for MySQL so that a my.cnf file is unnecessary. I simply read that file and told you what the defaults were set to. I also told you that by using a symlink

Re: [newbie] MySQL File Location

2005-03-21 Thread Derek Jennings
On Monday 21 March 2005 22:31, SOTL wrote: > On Tuesday 15 March 2005 11:21, Derek Jennings wrote: > > On Tuesday 15 March 2005 14:42, SOTL wrote: > > > Hi All > > > > > > I have created a partition on one of my computer to store critical > > > system data files called /System_Data. > > > > > > > >

Re: [newbie] MySQL File Location

2005-03-21 Thread Mikkel L. Ellertson
SOTL wrote: On Tuesday 15 March 2005 11:21, Derek Jennings wrote: On Tuesday 15 March 2005 14:42, SOTL wrote: Hi All I have created a partition on one of my computer to store critical system data files called /System_Data. I am trying to configure MySQL so that it will use /System_Data as its defau

Re: [newbie] MySQL File Location

2005-03-15 Thread SOTL
On Tuesday 15 March 2005 11:21, Derek Jennings wrote: > On Tuesday 15 March 2005 14:42, SOTL wrote: > > Hi All > > > > I have created a partition on one of my computer to store critical system > > data files called /mnt/System_Data. > > > > > > I am trying to configure MySQL so that it will use /mn

Re: [newbie] MySQL File Location

2005-03-15 Thread Derek Jennings
On Tuesday 15 March 2005 14:42, SOTL wrote: > Hi All > > I have created a partition on one of my computer to store critical system > data files called /mnt/System_Data. > > > I am trying to configure MySQL so that it will use /mnt/System_Data as its > default file storage. > > I looked for /etc/my.

Re: [newbie] MySQL

2005-02-18 Thread David G Stevenson
SOTL wrote: On Thursday 17 February 2005 15:04, David G Stevenson wrote: Brant Fitzsimmons wrote: SOTL wrote: Hi All As some of you are aware I started last week trying to make a data base using MySQL. I that light I have a nice book, some book examples, and questions that are not answered in the b

Re: [newbie] MySQL

2005-02-18 Thread SOTL
On Thursday 17 February 2005 15:04, David G Stevenson wrote: > Brant Fitzsimmons wrote: > > SOTL wrote: > >> Hi All > >> > >> As some of you are aware I started last week trying to make a data > >> base using MySQL. > >> > >> I that light I have a nice book, some book examples, and questions > >> t

Re: [newbie] MySQL

2005-02-17 Thread David G Stevenson
Brant Fitzsimmons wrote: SOTL wrote: Hi All As some of you are aware I started last week trying to make a data base using MySQL. I that light I have a nice book, some book examples, and questions that are not answered in the book. This computer is set up with all data located on a separate part

Re: [newbie] MySQL

2005-02-17 Thread Brant Fitzsimmons
SOTL wrote: Hi All As some of you are aware I started last week trying to make a data base using MySQL. I that light I have a nice book, some book examples, and questions that are not answered in the book. This computer is set up with all data located on a separate partition called /home/trunk

Re: [newbie] MySQL WOn't Start

2004-12-19 Thread Derek Jennings
On Saturday 18 December 2004 20:30, EE wrote: > Dears, > > I can't run MySql it says "ERROR 2002: Can't connect to local MySQL > server through socket '/var/lib/mysql/mysql.sock' (2) > > > Can you help What do you see in the syslog when you restart the mysql service? derek -- www.jennings.homeli

Re: [newbie] MySQL WOn't Start

2004-12-19 Thread Paul
Op Sat, 18 Dec 2004 23:30:21 +0300 schreef EE: >Dears, > >I can't run MySql it says "ERROR 2002: Can't connect to local MySQL >server through socket '/var/lib/mysql/mysql.sock' (2) Does the file /var/lib/mysql/mysql.sock exist? If not, then probably the MySQL daemon is not running. Paul -- The

Re: [newbie] MySQL 4.1 doesn't start in 9.2, 10.0 and 10.1

2004-10-08 Thread Adolfo Bello
On Fri, 2004-10-08 at 11:00, Stew Benedict wrote: > On Fri, 8 Oct 2004, Adolfo Bello wrote: > > > Hi: > > > > I've worked with MySQL 4.1 since the alpha release (4.1.0). I always > > download the latest rpms from mysql.com and install them with rpm. Until > > version 4.1.4 every thing was just fi

Re: [newbie] MySQL 4.1 doesn't start in 9.2, 10.0 and 10.1

2004-10-08 Thread Stew Benedict
On Fri, 8 Oct 2004, Adolfo Bello wrote: > Hi: > > I've worked with MySQL 4.1 since the alpha release (4.1.0). I always > download the latest rpms from mysql.com and install them with rpm. Until > version 4.1.4 every thing was just fine. > > However, when I tried to install 4.1.5 rpms in my full

Re: [newbie] mysql

2003-02-18 Thread Robert Wideman
>> > [root@rwideman2 root]# mysql -u root mysql >> > ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO) >> >> It should ask you for a password here (note that it said "using >> password: no"). The only reason I know why it wouldn't do so is when >> you have somewhere defined

Re: [newbie] MySQL-shared-3.23.52-1.i386.rpm installation error

2003-02-04 Thread Adolfo Bello
On Tue, 2003-02-04 at 13:52, Paul wrote: > In reply to Márkus's mail, d.d. Tue, 04 Feb 2003 18:47:49 +0100: > > I got it to work by following this document: > > www.unixodbc.org/doc/OOoMySQL.pdf > > Good luck! > Paul Using MyODBC-3.51.05-1 and unixODBC-2.2.4, I had to create a symbolyc link wit

Re: [newbie] MySQL-shared-3.23.52-1.i386.rpm installation error

2003-02-04 Thread Paul
In reply to Márkus's mail, d.d. Tue, 04 Feb 2003 18:47:49 +0100: I got it to work by following this document: www.unixodbc.org/doc/OOoMySQL.pdf Good luck! Paul >To get OO work with MySQL, tried to install on MDK 9.0 ODBC drivers as >instructed in the 'OO ODBC howto' doc but >MySQL-shared-3.2

Re: [newbie] mysql

2003-02-01 Thread Zane Minninger
I know I didn't ask for the help, but I did want to say thank you Adolfo, you just resolved one of my many issues. I hope it works for you Benjamin. After a quick re-boot phpnuke was able to setup its database. :) Zane Minninger At 04:16 PM 1/31/2003, Adolfo Bello wrote: On Fri

Re: [newbie] mysql

2003-01-31 Thread Adolfo Bello
On Fri, 2003-01-31 at 16:16, Benjamin Jeeves wrote: > Hi all > > For some reason mysql does not boot up on my system in the Control Center it > is marked on boot but stopped can any one help on why > Thank You > > > > Benjamin Jeeves I had the same problem overhere. Starting fine now after is

Re: [newbie] mysql

2003-01-31 Thread Scott
On Fri, 2003-01-31 at 15:16, Benjamin Jeeves wrote: > Hi all > > For some reason mysql does not boot up on my system in the Control Center it > is marked on boot but stopped can any one help on why > Thank You > > > > Benjamin Jeeves > > > > Want to buy your Pack or Services from Mandr

Re: [newbie] MySQL users DB corrupted

2003-01-10 Thread Benjamin Pflugmann
Hi. On Thu 2003-01-09 at 11:21:49 -0800, [EMAIL PROTECTED] wrote: > I have a small problem where a power outage has corrupted the user database > for mysql, now no users can authenticate/manipulate any databases hosted by > the MySQL Engine... This is rather annoying since I am no longer able to >

Re: [newbie] MySQL users DB corrupted

2003-01-09 Thread Adolfo Bello
On TIf there is no other solution, is it possible to import the existing > > database I have (used for inventory purposes) into a fresh mysql install? I > > cant export anything, and the database files are basically flat files at > > this point... A good web resource would also be appreciated! > >

Re: [newbie] MySQL users DB corrupted

2003-01-09 Thread Stephen Kuhn
On Fri, 2003-01-10 at 06:21, Cory wrote: > I have a small problem where a power outage has corrupted the user database > for mysql, now no users can authenticate/manipulate any databases hosted by > the MySQL Engine... This is rather annoying since I am no longer able to > administer the databases,

Re: [newbie] MySQL

2002-11-26 Thread Frank Mertens
On Fri, 2002-11-22 at 21:23, Jordan Elver wrote: > Hi, > Can anyone tell me how to remove the MySQL rpms without KDE disapearing with > it? When trying to remove, it also wants to remove the various KDE rpms? > > TIA, > Jord > -- > Jordan Elver > http://www.jordanelver.co.uk > "Press any key to

Re: [newbie] mysql

2002-06-14 Thread Miark
I learned how to get around in MySQL using the documentation at their site: mysql.com. Learn their material first, then you can spend yer money on a slightly more advanced book if you need to. Miark "Schwenk, Jeanie" <[EMAIL PROTECTED]> saith: > I need to learn mysql. I looked at bookpool a

RE: [newbie] mysql

2002-06-14 Thread Franki
ome of the guys that developed MySQL.. got my recommendation. rgds Frank -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of daRcmaTTeR Sent: Saturday, 15 June 2002 1:36 AM To: '[EMAIL PROTECTED]' Subject: Re: [newbie] mysql On Fri, 14 Jun 2

Re: [newbie] mysql

2002-06-14 Thread David Little
On Friday 14 June 2002 6:36 pm, you wrote: > On Fri, 14 Jun 2002, Schwenk, Jeanie wrote: > > I need to learn mysql. I looked at bookpool and there are too many > > books to pick from. Can anyone give me a recommendation? I found Sams Teach yourself Mysql in 21 days and O'Reilly's Mysql & Msql

Re: [newbie] mysql

2002-06-14 Thread daRcmaTTeR
On Fri, 14 Jun 2002, Schwenk, Jeanie wrote: > I need to learn mysql. I looked at bookpool and there are too many books to > pick from. Can anyone give me a recommendation? I'm a C/Java programmer so > it doesn't have to be too basic, just thorough and preferably not put me to > sleep. > > J

Re: [newbie] Mysql! How do I set the root password from a base install?

2001-06-08 Thread Paul Cox
On Thursday, Jun 07, 2001, h3rb wrote: > I am gonna reply to you with a Quote from my first message: > > "I can't add any database's or anything cause it tells me that root@localhost > is denied access. " > > Emphasize on the "anything" part! Did you even try what I suggested? -- [EMAIL PRO

Re: [newbie] Mysql! How do I set the root password from a base install?

2001-06-07 Thread h3rb
I am gonna reply to you with a Quote from my first message: "I can't add any database's or anything cause it tells me that root@localhost is denied access. " Emphasize on the "anything" part! h3rb On Thursday 07 June 2001 10:54, Paul Cox wrote: > On Thursday, Jun 07, 2001, h3rb wrote: > > How

Re: [newbie] Mysql! How do I set the root password from a base install?

2001-06-07 Thread Paul Cox
On Thursday, Jun 07, 2001, h3rb wrote: > How do I set the root password for mysql? I can't add any database's or > anything cause it tells me that root@localhost is denied access. I switch to > the user mysql and try to change the password that way. And mysql tell's me > that the user mysql

RE: [newbie] Mysql! How do I set the root password from a base install?

2001-06-07 Thread Mark Johnson
http://www.mysql.com/doc/D/e/Default_privileges.html shell> mysql -u root mysql mysql> UPDATE user SET Password=PASSWORD('new_password') WHERE user='root'; mysql> FLUSH PRIVILEGES; > -Original Message- > From: h3rb [mailto:[EMAIL PROTECTED]] > Sent: Thursday, June 07, 2001 1:

Re: [newbie] MySQL

2001-02-20 Thread Allan Parreno
get a source at www.mysql.com, usually it is a mysql-x.x.tar.gz 1. tar -zxvf mysql-x.x.tar.gz 2. cd mysql-x.x.x 3. ./configure 4. make 5. make install 6. scripts/mysql_install_db 7. cp support-files/mysql.server /etc/rc.d/init.d/mysql 8. chmod a+x /etcrc.d/init.d/mysql 9. setup 10. System servic

RE: [newbie] MySQL and PHP question

2000-10-18 Thread Michael Hunter
I am having sort of the same problem, you can place all of your html, PHP files in the apache-htdocs folder. I believe this is the name of the root folder. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Kandace Little Sent: Wednesday, October 18, 2000 6:

Re: [newbie] Mysql for mandrake

2000-10-11 Thread KompuKit
Okay, I just got thru installing the Perl 5.6.0 base RPM, and the sister RPM...for the complete pkgfrom off the mandrake 7.1 rpmfind site. I installed DBI 1.13.rpm and a few other pkgs. I'm trying to setup a Mysql web interface admin...it requires DBI and DBD...I use to get DBI errors,when ca

RE: [newbie] Mysql for mandrake

2000-10-11 Thread Tyler Longren
Try http://www.mysql.com They've got source, and binary there. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of KompuKit Sent: Wednesday, October 11, 2000 4:25 PM To: Linux-Mandrake Subject: [newbie] Mysql for mandrake Where can I find a newer version of

Re: [newbie] mysql-where?

2000-10-10 Thread Mark Weaver
Ok... the paths for MySQL go like this: /usr/bin/mysql /usr/lib/mysql /usr/include/mysql /usr/share/mysql /usr/man/man1/mysql.1.bz2 The actual database(s) are located here: /var/lib/mysql -- Mark /* I never worry about the to-jams. * Once I've stuck my foot in my mouth *

Re: [newbie] MySQL RPMS

2000-09-06 Thread Steve Weltman
OOPS!! This was meant to be a private mail...Please disregard the previous. Thx! Steve W. - Original Message - From: "Steve Weltman" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, September 06, 2000 8:19 AM Subject: Re: [newbie] MySQL RPMS > Hi

Re: [newbie] MySQL RPMS

2000-09-06 Thread Steve Weltman
PROTECTED]> Sent: Wednesday, August 30, 2000 10:24 AM Subject: Re: [newbie] MySQL RPMS > Steve, > > When you installed MySQL, do you use PHP? I tried and it did not > recognize the MySQL specific commands. Did you hve to re-install PHP or > do use another program to access Sql d

Re: [newbie] MySQL RPMS

2000-08-30 Thread Paul
On Wed, 30 Aug 2000, Michael Hatzakis wrote: >Paul, > >One thing I tried is install it using the RPM manager and PHP did not >recognize it. Ie., did not recognize any of the sql commands, ie., >mysql_connect(). It did work on it's own, though. So, I took it out and >tried manual install and ./

Re: [newbie] MySQL RPMS

2000-08-30 Thread Michael Hatzakis
Steve, When you installed MySQL, do you use PHP? I tried and it did not recognize the MySQL specific commands. Did you hve to re-install PHP or do use another program to access Sql database? Thanks, Michael On Mon, 28 Aug 2000, Steve Weltman wrote: > Hi Paul, > > There is a new version (3.

Re: [newbie] MySQL RPMS

2000-08-30 Thread Michael Hatzakis
Paul, One thing I tried is install it using the RPM manager and PHP did not recognize it. Ie., did not recognize any of the sql commands, ie., mysql_connect(). It did work on it's own, though. So, I took it out and tried manual install and ./config using the instructions. Same. Then I remov

Re: [newbie] MySQL RPMS

2000-08-27 Thread Steve Weltman
Hi Paul, There is a new version (3.23) for Mandrake available from either mySQL or from http://news.freshmeat.net You can get all of the needed components in RPM format for easier installation. I did this in about an hour and I needed to uninstall my current version first. Just my 2 cents! Hop

Re: [newbie] MySQL RPM

2000-08-26 Thread Ajudgeone
mysql.com should be installed already though (GPL)

Re: [newbie] mySQL installation

2000-02-17 Thread SPECTRE
yes, whaddya wanna know? -- > From: Marc Herms (Mercator GmbH) <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Subject: [newbie] mySQL installation > Date: 15 February 2000 16:55 > > WHO could help me with mySQL installation? > > marc > > * > * MERCAT