Re: MySQL question

Have a look at what the error logs say. If that doesn't help, post the command used and error messages/logs (if relevant) to the list. - Original Message - From: "MIKE TURNER" <[EMAIL PROTECTED]> To: "MySQL" <[EMAIL PROTECTED]> Sent: Thursday, July 19, 2001 2:05 Subject: MySQL question

Re: help connection erroe

Try connecting to 'localhost' instead unless your web server is different from your mysql server in which case, you'll need to give root permission to connect from 209.198.250.5. If not, try posting some code to the list. It'll make it easier for us to solve your problem. - Original Message

Re: I am facing this error [ Urgent ]

This is a very common problem. It is documented in the manual and also in other places as Edna has already mentioned. Your php code has nothing to do with the cause of the problem. Basics: 1. Your server isn't running 2. Your paths to the socket file are incorrect. (Check php and mysql setting

Re: Help Requested

This is a very common problem and can be found in the archives of this list as well as the mysql documentation. - Original Message - From: "Robert Sochor" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, July 14, 2001 2:42 Subject: Help Requested > Dear XYZ > > I am running b

Re: INSERT INTO ... SET ...

|/ /_ __/ __/ __ \/ /Mr. Jorge del Conde <[EMAIL PROTECTED]> > / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer > /_/ /_/\_, /___/\___\_\___/ Mexico City, Mexico > <___/ www.mysql.com > > > > -Original Message- > From: Rolf Hopkins [mailto:[EMAIL

INSERT INTO ... SET ...

Hi all, A week ago or so, someone on this list had a problem with inserting data. I thought the reason was because they had mixed up the INSERT and UPDATE statements. ie. INSERT INTO table_name SET column1=a_value, column2=a_value, ... However, they said this statement works from the MySQL pro

Re: simpify chinese and traditional chinese

Yes, Chinese characters isn't much of a problem. They will be stored in ASCII format unless you are using a Chinese system for your server, which should then display it as Chinese characters. Sorting isn't too much of a problem as long as sorting is done in ASCII order. I have done it this way

Re: HELP!!!!! How to set root password?

- Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, July 12, 2001 7:20 Subject: HELP! How to set root password? > > > I've been reading the documentation for the last 3 hours in search for > the answer to this question, to no avail. To preserve th

Re: mysql-3.23.35

If you do ps -ef | grep mysql, I think you'll find that the server is already running. - Original Message - From: "Michael" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, July 12, 2001 8:03 Subject: mysql-3.23.35 Hi, I have just installed mysql-3.23.35 on a linux - mandrak

Re: Root Login Problem

Sorry, I made a mistake it's password not --password ie. [root@mail mysql]# mysqladmin password FalsePass not [root@mail mysql]# mysqladmin -password FalsePass - Original Message - From: "Rolf Hopkins" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <

Re: auto_increment not incrementing

In what way doesn't it work? Works fine for me. - Original Message - From: "Mike Mike" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, July 12, 2001 5:18 Subject: auto_increment not incrementing > Hello, > When I submit data it will not submit data into the > database unles

Re: Root Login Problem

> [root@mail mysql]# mysqladmin -password FalsePass This is not as per documentation. Documentation says --password. - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, July 12, 2001 0:26 Subject: Re: Root Login Problem > >

Re: help me with "select" query

Best I can come up with is something like 2 words: SELECT c1.id FROM crossref c1, crossref c2 WHERE c1.word='word1' AND c2.word='word2' AND c1.id=c2.id 3 words: SELECT c1.id FROM crossref c1, crossref c2, crossref c3 WHERE c1.word='word1' AND c2.word='word2' AND c3.word='wo

Re: mysql problem

Changing your IP address shouldn't affect your MySQL access in that way. I would say you have done something else to cause those errors. You can look at skip grants in the manual. From what you have written, your web pages are accessing the DB as root. That spells D A N G E R. You should crea

Re: Need your helps!!!

Yes, looks like you're right, which means that the Introduction and Overview chapters of Replication need to be reviewed as it gives the impression that it can't be done. - Original Message - From: "Simon Green" <[EMAIL PROTECTED]> To: "'Rolf Hopkins

Re: Re[4]: saving in mysql

This is more like what we want to see and pointing us to which line causes the error would help even more. But from this, you're mixing up your INSERT and UPDATE statements for starters. What you have would be correct if you replaced INSERT INTO with UPDATE. For INSERT, it is a comma delimited l

Re: Need your helps!!!

No. That link is about one way Replication. A main server with backup servers and if the main server dies, a backup can take over. What was asked was if any one server is updated, all others are updated. I'm also interested but I very much doubt it can be done because there is nothing in the man

Re: saving in mysql

My guess is that you have logging on for php but it has problems saving to it's current location but I'm not psychic so I don't know. (ie. provide the list with some code) - Original Message - From: "Stink" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, July 09, 2001 7:05 Subje

Re: Relational Database WITHOUT server?

Of course there is no unix versions of Access. Microsoft wouldn't create anything to assist their competitor. If you are setting up a Linux machine, what's wrong with setting it up to run a DB server? MySQL would be quite suitable as it is quite easy to use, allows you to connect from Windows m

Re: F IRST TIME USER of MySQL

That's probably because you didn't set up access for root from www.mydomain.com If you have logged into the server through telnet, you shouldn't need the -h option. If you do, it should then be "localhost" and not yourdomainname. - Original Message - From: "Anoop K Gupta" <[EMAIL PROTEC

Re: Help - Selecting from many to many table.

I would say it is because you need and "or" in ct.Fk_Targets_Id='1' and ct.Fk_Targets_Id='3' and not an "and". How can a column equal 2 different values at the same time? - Original Message - From: "Simon" <[EMAIL PROTECTED]> To: "Mysql" <[EMAIL PROTECTED]> Sent: Sunday, July 08, 2001

Re: PHP and Mysql

Well, it's difficult to tell but I would say it would be your SQL statement but since you didn't provide us with that... - Original Message - From: "Kevin Smith" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, July 08, 2001 17:40 Subject: PHP and Mysql > Hi All, > > Has anyon

Re: Syntax question for a beginner..

h...now I know you can't do nested selects :\ > > - randy > = > r a n d y / sesser at mac.com > > > From: "Rolf Hopkins" <[EMAIL PROTECTED]> > > Date: Fri, 6 Jul 2001 13:57:27 +0800 > > To: "{ randy }" <[

Re: Syntax question for a beginner..

Even if sub-selects were available in MySQL (which they're not), that query would still not work as it will only select the values that are unique to tableA. What you would be looking at is something like: SELECT email FROM tableA UNION SELECT email FROM tableB But unfortunately, UNION is not a

Re: update

This is not possible at the moment and the best way I can think of is to separate them into 2 separate queries using the returned value of the select as the input value for the update. - Original Message - From: "Paulo Francioli DETRAN" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Fr

Re: mySQL & MS VB

Yes, you can run MySQL on a Windows machine and you'll need MyODBC if you're connecting through ODBC. - Original Message - From: "Simon Metz" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, July 06, 2001 9:05 Subject: mySQL & MS VB > I am developing a Visual Basic application

Re: newbie - connecting to data base with php sql_pconnectstatement

One reason could be the server isn't running. This problem has been documented, please RTFM. - Original Message - From: "Roger deBry" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, July 06, 2001 6:11 Subject: newbie - connecting to data base with php sql_pconnectstatement I

Re: Can't connect

Possibly because you haven't started the server. The manual contains information on this error in more detail. - Original Message - From: "MikeBlezien" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, July 04, 2001 6:27 Subject: Can't connect > What is the recommended proce

Re: SELECT query

- Original Message - From: "Craig Meyers" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, July 04, 2001 3:20 Subject: SELECT query > List, > > Our site is running mysql server version 3.22.32 > I'm a power user - not the DBA, so forgive my ignorance. > > Is it possible to c

Re: Ms-Access vs MySQL

MySQL doesn't support certain features such as foreign keys and sub-selects but may do so in the future. This is documented in the mysql manual. MS Access is not very suitable for networks especially on a large scale. - Original Message - From: "Wavyx" <[EMAIL PROTECTED]> To: <[EMAIL PR

Re: forget password in user table and no other user has access privilege to mysql database

Look up skip grants in the manual and in future I recommend the GRANT command. - Original Message - From: "harvin" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, July 03, 2001 13:56 Subject: forget password in user table and no other user has access privilege to mysql database

Re: Mysql error (Index page)

- Original Message - From: "help" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, July 02, 2001 3:55 Subject: Mysql error (Index page) > > I am getting a few errors on the index page of > my site. I am running the page on a windwos 2000 adv > server with Mysql and PHP. I

Re: problems with root password - can anyone help me?

You could try skip grants and fix it that way. And yes, it's in the manual. If not, you'll probably need to run mysql_install_db again. - Original Message - From: "Mihai Marinescu" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, July 02, 2001 3:42 Subject: problems with root pa

Re: Strange pseudo-coded query

- Original Message - From: "Thomas J Keller" <[EMAIL PROTECTED]> To: "Rolf Hopkins" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, July 02, 2001 2:49 Subject: Re: Strange pseudo-coded query > Rolf Hopkins wrote: > > This is way

Re: Strange pseudo-coded query

This is way off topic and you should seek an MS Access help list. [Zip Code Distance Extractor] could refer to any number of diff things such as a column in a table, a table name, a field on a form. The "!" also has several different meanings and you should be able to find it in help files. ---

Re: mysql/php query from 2 tables

- Original Message - From: "Felicia" <[EMAIL PROTECTED]> To: "mysql post" <[EMAIL PROTECTED]> Sent: Sunday, July 01, 2001 2:06 Subject: mysql/php query from 2 tables > im having problems getting results querying two tables but I am not sure of > the correct php syntax for the query stat

Re: Access to Other Databases Thru MySQL

You'll need MyODBC to connect from Access to MySQL. - Original Message - From: "Manuel Mesquita" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, July 02, 2001 0:52 Subject: Access to Other Databases Thru MySQL > Dear Sirs, > > We are new in MySQL. We work basically with Micros

Re: UPDATE/REPLACE command

P.S. You could also UPDATE 4 first with the new value and then DELETE 2. - Original Message - From: "Rolf Hopkins" <[EMAIL PROTECTED]> To: "Artem Koutchine" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Sunday, July 01, 2001 15:03 Subject: Re: UPD

Re: UPDATE/REPLACE command

No there isn't. You'll need to DELETE first and then UPDATE. Ie. delete 4 first and then update 2. - Original Message - From: "Artem Koutchine" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, June 29, 2001 22:43 Subject: UPDATE/REPLACE command > Hi! > > Was UPDATE/REPLACE co

Re: Multiplle update by key

If each record is being updated with exactly the same information you could the statement WHERE key IN (key1, key2, ...) Otherwise you'll need an update statement for each record. - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, June 29, 2001 21:41 Su

Re: Beginners Query

Try logging on as root. - Original Message - From: "LinuxTech Inc" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, June 27, 2001 14:16 Subject: Beginners Query > hi > > I am new user to mysql > I want to create a new database on my machine where mysql is installed at linux

Re: Conversion from Access JOIN syntax to MySQL JOIN syntax...

As it is such a big query, I don't have time to look at it for you but it may be easier if you convert the RIGHT JOINS to LEFT JOINS for starters. The manual does recommend LEFT JOINS, mainly for portability. First part would be something like (leg_activity LEFT JOIN leg_comm_hist ON (leg_comm_h

Re: Newbie

And what is the command you are using to connect? - Original Message - From: "Jason Brunk" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, June 27, 2001 7:00 Subject: Newbie hello all, I am kind of new to all the unix OS stuff. Lately i have been doing alot of work in

Re: Copy Record command

Don't know what a COPY RECORD command is but my best guess is that you are looking for a create table with a select clause. - Original Message - From: "Klein, Tracy ISTA:EX" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, June 27, 2001 0:11 Subject: Copy Record command > He

Re: deleted mysql.sock

You just crashed the mysql server. Just restart it. - Original Message - From: "Michael Kirschenbaum" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, June 22, 2001 21:24 Subject: deleted mysql.sock > Hi, > I accidentaly deleted the mysql.sock file, does anyone know how to > r

Re: Setting mySQL for a user

You can start with the mysql manual. Then there is Paul DuBois book, people say it's supposed to be good. - Original Message - From: "WebNomad Inc." <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, June 20, 2001 4:39 Subject: Setting mySQL for a user > Hello all, > > I'm a

Re: cascade delete's

That requires the use of foreign keys and that's not supported. - Original Message - From: "Sibel Toprakkiran" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, June 19, 2001 16:23 Subject: cascade delete's > Hi, > > I wanted only to know, if there is a possibility in > mysql f

Re: create database problem

"mysqladmin --help" will provide you with a list of switches you can use. If you add "-u root" to the shell command , perhaps you'll have more success. - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, June 19, 2001 16:37 Subject: create database proble

Re: please help (dumb permissions thing?)

- Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, June 19, 2001 9:20 Subject: please help (dumb permissions thing?) > Access denied for user: '@localhost' to database 'netsloth'Could not > drop database netsloth Don't know what command you used but I

Re: access denied problem

mysqladmin -u root password mysql "password" is used to change the password. "-p" is used to log on if a password has already been set. Don't know exactly what you want to do but possibly you're looking for mysqladmin -u root -p password your_new_password If that doesn't work and you don't kno

Re: MySQL on VB

Can connect using MyODBC. - Original Message - From: "Andrew" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, June 15, 2001 13:52 Subject: RE: MySQL on VB > > I need some help. > > I would like to know if VB can interface directly with MySQL. > If possible, then how shall I go

Re: What's wrong here?

Well, that isn't much to go on. I suggest you put a few print statements to find out what's happening and also try the sql statement in the mysql prompt to see if the sql statement does what it is suppose to. Remember, if you're printing this in a table, error messages and results may not always

Re: What's wrong here?

It would help if we knew what the error or problem was? - Original Message - From: "Vladimir Kravtsov" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, June 15, 2001 13:13 Subject: What's wrong here? "); echo(" "."$choice_percentage"."\%"); } } } ?> Pl

Re: Relationships???

If you are really after referential integrity then perhaps you should consider another database or you could always modify the code. - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, June 15, 2001 8:32 Subject: Relationships??? > Hello all, > > Without

Re: mySQLGUI Error

No, you need to add a user to MySQL that is allowed access from that host. See the GRANT statement in the manual. I'm also betting that that is a dynamic IP address in which case you'll probably have to setup a user with access from 192.168.0.% - Original Message - From: "Anthony Olugben

Re: Installation problem

What do the mysql error logs say? - Original Message - From: "Gerry Tool" <[EMAIL PROTECTED]> To: "Rolf Hopkins" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Tuesday, June 12, 2001 11:33 Subject: Re: Installation problem > No, the daemon

Re: Installation problem

Has it already started? Check with ps -ef | grep mysqld - Original Message - From: "Gerry Tool" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, June 12, 2001 10:38 Subject: Installation problem > I have just installed mysql on a RH7.1 system from > mysql-3.23.38-pc-linux-gnu

Re: Table won't update

Will the update statement work under the mysql prompt? - Original Message - From: "Vladimir Kravtsov" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, June 12, 2001 8:39 Subject: Table won't update The table sitesats won't update and shows no errors! (even though there are two

Re: MYSQL error

There are settings that could probably fix the problem then but I would need to RTFM. - Original Message - From: "Aldo Spano" <[EMAIL PROTECTED]> To: "Rolf Hopkins" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Tuesday, June 12, 2001 0:03 Subjec

Re: MySql keeps crashing

just hoping that the MySql developers would see my post and tell me > that "normal shutdown" messages will NOT occur if the database crashes...so > I can go back to him and prove he's lying to me. > > Thanx, > Chuck > > - Original Message - > From: Rolf

Re: Pornographer will trade for Help with web based MySql

I'm sure most people on this list aren't interested in your services. You can start by reading the relevant manuals or you could hire a professional to create the db for you. This is a great list for getting help on specific problems provided you've tried to help yourself first. Also, if you do

Re: MySql keeps crashing

This doesn't make much sense to me. By "host server" you mean your ISP? If so how are you able to view the logs? Are you DB admin or something? By the looks, someone is able to get in and shut it down. This can only happen with admin rights or mysql server wasn't set up correctly in the first

Re: Selecting Distinct with MySQL and PHP4??

There's a list of functions in the php manual that allow you to connect, pass sql statements to and retrieve data from a database. - Original Message - From: "Jeffrey L. Fitzgerald" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, June 11, 2001 9:54 Subject: Re: Selecting Distinc

Re: help with select

I presume that is just an example as people's names don't make very good primary keys. Something like SELECT h2.* FROM hotel h1, hotel h2 WHERE h1.name = 'BILL' AND h1.room = h2.room I haven't tried it so you'll have to play around with it a bit. - Original Message - From: "Jaime Teng"

Re: What things does MySQL lack as of yet

The mysql manual contains a list of what's lacking and whether or not these features will be implemented in the future. - Original Message - From: "John Meyer" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, June 11, 2001 10:13 Subject: What things does MySQL lack as of yet >

Re: Password encryption

generate a new one if it wasn't. - Original Message - From: "WCBaker" <[EMAIL PROTECTED]> To: "Rolf Hopkins" <[EMAIL PROTECTED]>; "MySQL" <[EMAIL PROTECTED]> Sent: Monday, June 11, 2001 8:31 Subject: Re: Password encryption > >

Re: PHP Prob contd.

You have 1 too many commas. Remove the comma before the from clause in your sql statement. - Original Message - From: "Vladimir Kravtsov" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, June 11, 2001 11:18 Subject: PHP Prob contd. Well I fixed that part so now the file looks

Re: simpe select return not all rows - and flush

Have you tried ismchk/myismchk? - Original Message - From: "Artem Krsheminsky" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, June 11, 2001 2:01 Subject: simpe select return not all rows - and flush > Hi > > i'm newbie and have the problem - > sometimes after some INSERT and

Re: Password encryption

er logs on and that gets passed to the next page instead of the password itself. Other than that, I don't think I can be much more help. - Original Message - From: "Leon Mergen" <[EMAIL PROTECTED]> To: "Rolf Hopkins" <[EMAIL PROTECTED]> Cc: <[EMA

Re: Password encryption

I used the function password() if that helps but of course you can't "decode" it. - Original Message - From: "Leon Mergen" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, June 09, 2001 22:44 Subject: Re: Password encryption > Anyone has any idea how much this encryption meth

Re: php/mysql question

- Original Message - From: "Adrian D'Costa" <[EMAIL PROTECTED]> To: "Rolf Hopkins" <[EMAIL PROTECTED]> Cc: "Mysql Mailing List" <[EMAIL PROTECTED]> Sent: Friday, June 08, 2001 17:47 Subject: Re: php/mysql question > On Fri,

Re: php/mysql question

- Original Message - From: "Adrian D'Costa" <[EMAIL PROTECTED]> To: "Mysql Mailing List" <[EMAIL PROTECTED]> Sent: Friday, June 08, 2001 13:59 Subject: php/mysql question > Hi, > > I am not sure whether this relates to this list or the (not working) php > list. > > For simplicity: I ha

Re: Rookie admin needs install help

Strange. I've never had any problems with the RPMs - Original Message - From: "Duane Douglas" <[EMAIL PROTECTED]> To: "Rolf Hopkins" <[EMAIL PROTECTED]> Cc: "Patrick Malone" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Th

Re: MYSQL error

What is the error? - Original Message - From: "Aldo Spano" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, June 07, 2001 21:34 Subject: MYSQL error > I use mysql with IMP, a webmail application very nice and fast. Till I used the > old version of Mysql 3.22.xx i had no probl

Re: Select query

You could try something like mysql> select sequence_id from sequence_protein -> where truncate(mol_wt, 2) = 53211.62; And, if you look truncate up in the manual, I think it even gives an explanation as to why. - Original Message - From: "Hannes Niedner" <[EMAIL PROTECTED]> To: <[EMA

Re: INSERT.

Check out last_insert_id in the manual. - Original Message - From: "Jorge Oliveira" <[EMAIL PROTECTED]> To: "Mysql@Lists. Mysql. Com" <[EMAIL PROTECTED]> Sent: Friday, June 08, 2001 7:43 Subject: INSERT. > Hi, > > I have two tables in my database: > > #TB1 > ID_tb1 (auto-incremented)

Re: Pound (£) Symbol and MySQL

- Original Message - From: "technical Support" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, June 08, 2001 4:52 Subject: Pound (£) Symbol and MySQL > Hello All, > > When I insert data submitted via a web page into mySQL, the pound (£) > symbol gets converted to something lik

Re: Cant connect

Well, from the error, one of them is not correct. Since you didn't supply the code you used, my best guess is your host is incorrect. I am guessing you have something other than 'localhost'. If that's not working, '127.0.0.1' may do the trick. If not, check your grant tables again. - Orig

Re: What am I missing?

You don't need MySQL-bench-3.23.38-1.i386.rpm to run mysql but if you still want to use it, you need to install perl first. - Original Message - From: "Mike Jimenez" <[EMAIL PROTECTED]> To: "Mysql" <[EMAIL PROTECTED]> Sent: Friday, June 08, 2001 1:35 Subject: What am I missing? > rpm -i

Re: installation problem

Is this a new installation? Then the -p option is not required. -p is only used once you have set the initial password. - Original Message - From: "Michela Robustelli" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, June 07, 2001 23:20 Subject: installation problem > i've

Re: Please can you help me find the right file to download

There is no full blown graphical version of the database itself. You still need to download the normal version itself and then download a graphical front end for administration. The main software you need can be found at http://www.mysql.com/downloads/mysql-3.23.html and the graphical interface

Re: sql server or mysql

This all depends on your needs. If you're looking for speed and reliability, you can't beat MySQL on a unix based system. However, MySQL lacks features such as subselects and foreign keys. Some are still on the way while others will never be implemented. A good place to start would be the mysq

Re: mysql daemon aborting abnormally (rh linux 6.2)

Sure it hasn't already started? Do ps -ef | grep mysqld to find out. - Original Message - From: "Duane Douglas" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, June 07, 2001 12:57 Subject: mysql daemon aborting abnormally (rh linux 6.2) > hi gang! > > after much hassle, i s

Re: Rookie admin needs install help

Unix rookie as well? 0 | 0 \__/ Off the top of my head, "rpm -i file_name" should do it. I usually use redhat's gui. "man rpm" will give you more details. - Original Message - From: "Duane Douglas" <[EMAIL PROTECTED]> To: "Rolf Hopkins&quo

Re: VB3 and mysql

Should be able to do it using myODBC. But why such an old version? - Original Message - From: "Hillier" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, June 07, 2001 8:53 Subject: VB3 and mysql To whom it may affect Jonas Norrman pass this question on to you Is VB3 c

Re: Rookie admin needs install help

I don't know whether slackware has the RPM software but if it does, use it. You won't have these problems then. Otherwise I can only suggest you try one of the other binaries instead. - Original Message - From: "Patrick Malone" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday,

Re: Table Creation woes

describe is a reserved word and so is fulltext, I think. - Original Message - From: "Matt "TrollBoy" Wiseman" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, June 07, 2001 5:52 Subject: Table Creation woes > can someone tell me what I'm doing wrong here?I keep getting th

Re: permissions

And what command did you use to create the user? - Original Message - From: "Peter I. Hansen" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, June 07, 2001 5:32 Subject: permissions > Hi > > I'm currently adding users to a MySQL server on a LAN (www.xxx.yy), and > I want th

Re: Problem in migrating from mysql to Oracle

I am pretty sure that Oracle Migration Workbench is an Oracle product, am I correct? In that case you'll probably have to seek out the Oracle community. Hehehe. good luck. Only one thing though. I wouldn't think you'd be able to migrate the mysql database as that is the security database

Re: MySQL tool

As far as I am aware, mysqlgui is supposed to do exactly that. - Original Message - From: "Muhammad Asif" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, June 06, 2001 23:11 Subject: MySQL tool > Is there any tool available for managing graphically databases,tables as > wel

Re: MySql Client

Yes there is. Just install the MySQL client in the normal way. When you add users, ensure they can access the server from a remote machine. See the GRANT and REVOKE statements. When they log in, they must specify the address of the MySQL server using the -h option. - Original Message

Re: PHP & MySQL

- Original Message - From: "Michele Santucci" <[EMAIL PROTECTED]> To: "Rolf Hopkins" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, June 06, 2001 15:33 Subject: Re: PHP & MySQL > > > How'd you put it into the database

Re: PHP & MySQL

How'd you put it into the database in the first place? I'm betting that, if you look at your database directly (not through a UI), you'll find the data is stored as "

Re: which the best

I'm not getting into any OS wars here, but just to say I chose a unix based system due Microsoft's poor record with stability. I need something that I can rely on to stay up and running and Windoze doesn't fall into that category. - Original Message - From: "Sommai Fongnamthip" <[EMAIL

Re: create username/password with mysqladmin???

Wouldn't it be easier just to log into mysql and use the GRANT & REVOKE commands. - Original Message - From: "Duane Douglas" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, June 05, 2001 22:28 Subject: create username/password with mysqladmin??? > hello, > > i'm running mysql

Re: Have you seen this error message?

Sorry, can't remember exactly as I don't use Windoze but I do know you don't use mysqld.exe on win98. Do a search of the archives for the past few weeks and you'll find your answer. - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, June 05, 2001 20:01

Re: What is the error in this sql query

I would say line 2, DEFAULT 0 not DEFAULT '0'. - Original Message - From: "Syed sumair" <[EMAIL PROTECTED]> To: "MySQL List" <[EMAIL PROTECTED]> Sent: Friday, June 01, 2001 7:11 Subject: What is the error in this sql query > What is the error in this sql query ??? >

Re: Help! MySQL variables laugh at me

. - Original Message - From: "Luca Accomazzi" <[EMAIL PROTECTED]> To: "Rolf Hopkins" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, June 04, 2001 20:47 Subject: Re: Help! MySQL variables laugh at me > > I have only had a quick look o

Re: Help! MySQL variables laugh at me

I have only had a quick look over this and already have a question for the simple example you've provided. How are you determining the last value entered before entering the new value? The only way I see you of effectively accomplishing this is through the use of a datetime column. Or am I miss

Re: remote DB

If your not the admin of the DB, you'll have to ask the DB's admin for your login and password. If you are the admin, you'll need to RTFM about DB security and the GRANT and REVOKE statements. And no, it's not a good idea to allow connections using the root user to perform anything else other th

  1   2   3   4   5   >