automatic server start paramaters

On a mandrake 8.2 machine running the mysql rpm for that linux distro (mysql 3.23.??, I think) I have a testing and programming box, only one user is connecting to the database at a time. Now, the mysqld startup sequence automatically starts 5 occurances of the mysqld server. Id like to

Fwd: NDN: automatic server start paramaters

Dear MySQL list monitors... Please do something about the following address that has apparently joined the list. every time I send a message to the list, I get a bouned message saying that the message is undeliverable. Thanks From: Mailer-Daemon [EMAIL PROTECTED] To: [EMAIL PROTECTED]

Re: Get the next AUTO INCREMENT value for a column

To the originator of this thread: While what you are asking is possible, Id like to put my two cents in and ask you please not to do it. If this is a production database, you have no idea how helpful it will be for you to know by those missing pk numbers that something was deleted manually

Re: Re: GUI managers for Linux

Victoria, You asked me to be sure that the information going into the MyCC dialog box about the server was correct, and it is, port, user, password, and host, but still no connect, php can even connect to the database with the server/user/password triple. so back to my original question,

Re: GUI managers for Linux

Victoria, sorry it has taken so long to get back to you, Ive had a partition table problem that has taken a couple of days to fix anyway, Using MyCC, in the database connection dialog, I have the host localhost a valid user name, and password Identified the port as the default 3306 but dont

GUI managers for Linux

Ive downloaded and sucessfully installed both mysqlgui, and mycc from the mysql.com site for some wierd reason I cant connect to the database with either of them I can with the text mysql client, and the text mysqladmin I have created a database, and granted rights to that database to a user.

RE: mySQL and innoDB

The insert into b values ('BBB', NULL) statement should fail under the conditions you describe, BBB was not inserted into the A table, and therefore the foreign key constraint fails as it should. Rance Hall 308.238.2455 Internal Office Extensions: 2455 or 6655 PC Programmer, The Buckle, Inc

RE: mySQL and innoDB

column should fail inserting anything into that column that isn't in the referenced column should fail, and it does. so my apologies for my mistake from earlier Rance Hall 308.238.2455 Internal Office Extensions: 2455 or 6655 PC Programmer, The Buckle, Inc. [EMAIL PROTECTED] -Original Message

RE: mySQL and innoDB

-Original Message- From: Alain Del Giust [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 09, 2002 12:48 PM To: Christopher Thompson; [EMAIL PROTECTED] Cc: Rance Hall Subject: Re: mySQL and innoDB I am just testing mySQL so I will be able to use it instead of Oracle Sybase

RE: question

else, I think its a great tool, and it saves all that web clicking. Rance Hall 308.238.2455 Internal Office Extensions: 2455 or 6655 PC Programmer, The Buckle, Inc. [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 02, 2002 4:02

Using MySQL text column with PHP4

and maintain line feeds/carriage returns while still respecting other text layout commands? Rance Hall 308.238.2455 Internal Office Extensions: 2455 or 6655 PC Programmer, The Buckle, Inc. [EMAIL PROTECTED] - Before posting, please check

RE: Using MySQL text column with PHP4

nl2br() works, thanks for the info manual stinks on this subject example code should be something like: $newtext = nl2br($oldtext); Rance Hall 308.238.2455 Internal Office Extensions: 2455 or 6655 PC Programmer, The Buckle, Inc. [EMAIL PROTECTED] -Original Message- From: Mat

RE: running the server problem

a source install. Good Luck Rance Rance Hall 308.238.2455 Internal Office Extensions: 2455 or 6655 PC Programmer, The Buckle, Inc. [EMAIL PROTECTED] -Original Message- From: Bob Lockie [mailto:[EMAIL PROTECTED]] Sent: Monday, April 01, 2002 3:50 PM To: mysql mailing list Subject: running

Re: Server startup error on Linux

Ok Egor, here goes (not that it will give you any better information than I did already but since you asked...) exerpt from .err file follows 020318 14:30:48 mysqld started 020318 14:30:49 /usr/libexec/mysqld: Table 'mysql.host' doesn't exist 020318 14:30:49 mysqld ended exerpt from

Re: Server startup error on Linux

Egor: Yes, im sure that the host.xxx tables are in the directory I specified to the mysql_install_db script. One thing to note.. This is a software package for my distro... I did not compile from source so I dont know what options were used in the compile process. It may be that the server

server startup error on linux

Ok, I guess Im gonna have to do this again I have a Slackware 8.0 distro with the apache, php, and mysql install pkgs off of the cd I am logged in as root (not su'ed to root) and run the mysql_install_db script I run it with or without the --user=mysql qualifier in either case the databases

Re: Server startup error on Linux

I issued the chown command as indicated by Andreas but it doesnt help I still get the Table mysql.hosts doesnt exist I know that all the tables created by mysql_install_db are infact owned by mysql but the server daemon still cant find them what next?

server startup error

Hello all I have a slackware 8.0 distro that includes mysql 3.39.x (I'm not at that computer now, so that could be wrong slighly) install pkg I have installed it, and I can get it to run with the --skip-grant-tables option. When I try to run safe_mysqld without the skip option I get the

Re: server startup error

the mysql database directory, and all its files? You should have run it as mysql_install_db --user=mysql Rance Hall wrote: Hello all I have a slackware 8.0 distro that includes mysql 3.39.x (I'm not at that computer now, so that could be wrong slighly) install pkg I have installed it, and I can