Can't connect to the sqld server

To whom it may concern, I have trouble to connect to mysql. I use a few commands to log in, but fail. The command that I use is "C:>\C:\mysql\bin\mysqld --console", it gives error message as follows: Can't start server: Bind on TCP/IP port: No error 041107 20:06:25 Do you already have another

sovle the problem by myself

Hi, Sorry to bother you by sending the previous email. I have figured out the mistake that I made. I forgot to type the command "C:\mysql\bin\mysqladmin -u root shutdown" after I exited mysql last time. After I typed this command, I can connect to mysql successfully. Please ignore my previous e

Re: Completely remove MySQL?

At 14:40 11/7/2004, Michael Stassen wrote: > >That's using a shotgun to kill a gnat. That's why I have large gaping holes in my walls. >The IP used by phpmyadmin is set in >the config.inc.php file in the phpmyadmin directory. Just edit this file to >change the old setting to the new value.

Re: PHP/MySQL Problem

Are you running the 2 queries at the same time? they should be run 1 at a time. What does mysql_error() say? use it when you are checking the result set (if (!$result) { echo "Error: " . mysql_error();}Are the result sets being sent to 2 different identifiers? Just a few possibilities. Re

Temporary Upgrade for Cpanel?

I read on the Cpanel.net forum that you can start the 4.0.22 mysql with a --new switch to use it as 4.1.7 so you can see if its compatible with my software.   Is this true and exactly how? ThanksDonny LairsonPresidenthttp://www.gunmuse.com469 228 2183

Re: Completely remove MySQL?

Well, that depends on how you install phpmyadmin. A standard method is simply to download, unzip, and untar the distribution. If you do that on top of your old copy, or indeed, delete the old copy first, you will end up with the default config.inc.php. That is why I said "may replace". It is

Re: Completely remove MySQL?

On Sun, Nov 07, 2004 at 01:05:10PM -0600, W. D. wrote: > I can easily recreate the database--as well easily > reinstall PHP, MySQL, and phpMyAdmin--but how do I > remove everything so that the old IP address is > not referenced? > > By the way, where is this IP address being stored? In the phpMy

Re: Completely remove MySQL?

Please keep questions on the list. This is documented in the manual and . Michael Schalk Neethling wrote: Seeing that this would probably fix the phpMyAdmin problem,

Re: Completely remove MySQL?

On Sun, Nov 07, 2004 at 03:40:12PM -0500, Michael Stassen wrote: > Reinstalling phpmyadmin may replace config.inc.php with default settings, > but you'd still have to edit it to have the correct settings, so you may as > well just edit the one you already have. No, it won't trash an existing co

Re: Completely remove MySQL?

That's using a shotgun to kill a gnat. The IP used by phpmyadmin is set in the config.inc.php file in the phpmyadmin directory. Just edit this file to change the old setting to the new value. Problem solved. Reinstalling mysql and php, on the other hand, will have no effect. Reinstalling php

Completely remove MySQL?

Hi Folks, How does one completely remove MySQL from FreeBSD 4.9? My router died, and upon replacement I switched to static IP addresses on my local network. Unfortunately, When using phpMyAdmin to access a database, it tries to access the database at the old IP. I can easily recreate the databa

Re: massive fulltext indexes - what hardware?

We won't be serving concurrent queries. On Sun, 2004-11-07 at 10:41, Michael J. Pawlowsky wrote: > Another thing to consider is how many transactions per minute/second you > will need to serve. > > Mark Maunder wrote: > > I'm busy building an application that will have 10 million records, each

ebay - WOT

My wife has inspired the following: ebay woman! ebay woman! ebay woman, Sunday afternoon ebay woman, Sunday afternoon tops and pants, pots and pans never saw a womanso broke R. Whitney Transcend Development "Producing the next phase of your internet presence" http://xend.net Premium Quality

Re: Reorder a table

I'm still skeptical this will solve the problem, but here's one way to do what you asked: ALTER TABLE news_table DROP id, ORDER BY timestamp_column; That will drop the id column and reorder the table according to the values in timestamp_column. (If there have been no deletions, aren't the

Re: mysql NOT operator

On Sat, 06 Nov 2004 20:34:47 -0800, L a n a <[EMAIL PROTECTED]> wrote: > However, NOT operator gives an error: > 3. SELECT data_id from table WHERE keyword = a NOT keyword =b ( returns sql > error) AND NOT as well as OR NOT should work, I think. How do you think MySQL would be able to distinguish

RE: mysql NOT operator

Why would have to write not, when your keyword=a will not return b to begin with? But if this was really just an example you would do this. SELECT data_id from table WHERE keyword = a AND keyword != b Donny > -Original Message- > From: L a n a [mailto:[EMAIL PROTECTED] > Sent: Saturday,

Re: Reorder a table

Martin, The following will do the resequencing you requested. Hope it helps. create table temporary_table select * from the_table; set @T=0; update temporary_table set id=(@T:=(@T+1)), the_time=the_time order by the_time; delete from the_table; insert into the_table select * from temporary_table

Re: massive fulltext indexes - what hardware?

Another thing to consider is how many transactions per minute/second you will need to serve. Mark Maunder wrote: I'm busy building an application that will have 10 million records, each with a chunk of text - about 500 words each, on average. Does anyone have any benchmarks they can share with my

Re: Error 1045

http://dev.mysql.com/doc/mysql/fr/Access_denied.html Philippe Cabet wrote: Good morning, I’m a new Easyphp1-7 user. My computer environnement is Windows XP version 2002 service pack 1. Apache 1.3.27 PHP 4.3.3 PHPMYADMIN 2.5.3 MYSQL 4.0.15 My problem is; With EasyPhp menu, I choise Admini

order by in different languages..

Hi.. Listen to a peculiar problem. We need to order by a column which includes Greek language. The order by doesnot work correctly. The reason may be the administration's installation. So we need a nice trick for doing our job as fast as we can without interacting with the admin. Nice..eh? You can

Re: mysql NOT operator

Your question is a bit confusing. Here are the possibilities using AND: SELECT id FROM table WHERE col1 = a AND col2 = b; SELECT id FROM table WHERE col1 = a AND col2 <> b; SELECT id FROM table WHERE col1 <> a AND col2 = b; SELECT id FROM table WHERE col1 <> a AND col2 <> b; [ BTW, you can also wri

settingup mysql in suse linux

i have suse linux in my system and iinstalled mysql through rpms (server,client,devel,shared,max). iam having problem in setting it, as said in manual i created a group "mysql", user "mysql" and used mysqld_safe & to start the deamon, then i used mysqldadmin -u root password('password') to set t

Error 1034 - FULLTEXT Related?

Hello , i recently posted a message regarding table corruption upon deletes. I have done more poking around and notice that Myisamchk dies upon trying to check the FULLTEXT Index in my last message. I then see that 1034 error is popping up after a myisamchk -o fixes the table , and I try to de

Re: Error 1064 in three tables. How do I fix them.

Hi. LIMIT clause does not accept negative values. See: http://dev.mysql.com/doc/mysql/en/SELECT.html Leon Sargent <[EMAIL PROTECTED]> wrote: > > Good Morning. > > I am new to the list and new to Mysql. > > I am in the process of running a website and I need a little newbie help.

Error 1045

Good morning, I’m a new Easyphp1-7 user. My computer environnement is Windows XP version 2002 service pack 1. Apache 1.3.27 PHP 4.3.3 PHPMYADMIN 2.5.3 MYSQL 4.0.15 My problem is; With EasyPhp menu, I choise Administator, PhpAdmin, Gestion BDD. Then I tried to set a password on m