Re: Confused about privileges

It seems like a logical thing The grant statement applying to all databases/tables should be: *.* Chris Todd Cary wrote: I have created a table, "sfyc" and as root I issued the following: grant all on * to todd identified by 'my_password' with grant option; However, "

Confused about privileges

I have created a table, "sfyc" and as root I issued the following: grant all on * to todd identified by 'my_password' with grant option; However, "todd" cannot access "sfyc" with mysql -u todd -p sfyc And the mysql db contains the following: user table +---+--+ | host | user

Re: Blew MySQL away by accident

thank you again! Todd Michael Stassen wrote: Todd Cary wrote: Unfortunately, I blew MySQL away by replacing the MySQL control tables with others and not making a copy of the folder. My data is backed up, so that is not a problem, but I cannot reinstall MySQL and create the mysql directory

Blew MySQL away by accident

Unfortunately, I blew MySQL away by replacing the MySQL control tables with others and not making a copy of the folder. My data is backed up, so that is not a problem, but I cannot reinstall MySQL and create the mysql directory with the control tables (e.g. user, db, host). I have run "yum re

Re: Export in XML

h, Dan Greene -Original Message- From: John Griffin [mailto:[EMAIL PROTECTED]] Sent: Monday, December 01, 2003 10:49 AM To: Dan Greene; Todd Cary; Jay Blanchard Cc: [EMAIL PROTECTED] Subject: RE: Export in XML Look at http://www.mysql.com/doc/en/mysql.html. The -X option may gi

Re: Export in XML

John - Right under my nose!  Thanks Todd John Griffin wrote: Look at http://www.mysql.com/doc/en/mysql.html. The -X option may give you what you need. -Original Message- From: Dan Greene [mailto:[EMAIL PROTECTED]] Sent: Monday, December 01, 2003 9:57 AM To: Todd Cary; Jay

Re: Export in XML

Jay - I am not an expert with XML, however I use it with Delphi and Delphi's TClientDataset. In this usage, I use the builtin SaveTo and LoadFrom methods. Todd Jay Blanchard wrote: [snip] Is there a way to export/import MySQL tables in XML format? [/snip] Well Todd, it is a little more comp

Export in XML

Is there a way to export/import MySQL tables in XML format? Todd -- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Installing MySQL on Fedora

I tried installing MySQL on Fedora and all seemed to go fine, but there is no mysqladmin.   Have I missed something here? And I am not sure where the mysql executable resides.  The version is MySQL-3.23.58-1.i386.rpm Todd -- <>

DB2 express

ce, and I will have to address MySQL versus this product (as well as Oracle Express, though it seems to target a different market...) Thanks, Cary -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

DB2 express

ress, though it seems to target a different market...) Thanks, Cary -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Conversion

My commercial online web application currently handles 1 users with peak loadings of 100-500 concurrent hits. Windows 2000 Server, IIS 5.0, JRun 4.0 and Enterprise Database Engine. There is a considerable amount of write activity to 10 of the 60 tables. The total size of the data is 5-10GB

Re: Granting privileges

Roger - Thank you for taking the time to clarify that for me.  I was using "PHP with MySQL" and they are not clear on the differences I found and you explained. Thanks again Todd Roger Baklund wrote: * Todd Cary I did some experimenting and here is wh

Re: Granting privileges

ost column does not appear to work for me, and there is something different about "*" and "*.*". Todd Nils Valentin wrote: Hi Todd, 2003年 8月 4日 月曜日 08:01、Todd Cary さんは書きました: Nils - What is the difference between "*.* " and "* "? Hi To

Re: Granting privileges

#x27;some_password' with grant option; flush privileges; Jamie On Sun, 2003-08-03 at 09:52, Todd Cary wrote: I have installed Red Hat 9 and it installs MySQL. After logging on as root, I did the following: mysql mysql> use mysql; mysql> grant all -> on * -> to todd ind

Re: Granting privileges

lly committed. Also you should add the host to the username. grant all on *.* to [EMAIL PROTECTED] identified by 'some_password' with grant option; flush privileges; Jamie On Sun, 2003-08-03 at 09:52, Todd Cary wrote: I have installed Red Hat 9 and it installs MySQL. After

Granting privileges

I have installed Red Hat 9 and it installs MySQL.  After logging on as root, I did the following: mysql mysql> use mysql; mysql> grant all -> on * -> to todd indentified by 'my_password' -> with grant option; I then log out of mysql and log out as root.  Logged in as "todd" I type the followi

Restoring from a mysqldump

I have a file produced by mysqldump and I need to restore it. Can someone point me toward the instructions on how to do this? Todd -- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Restoring a DB

If I have a file, mydb.mbk that was created with mysqldump, how do I recreate/restore the DB? Do I run a command line using "mysql" with a switch and "mydb.mbk"? Todd -- Ariste Software, Petaluma, CA 94952 \n [EMAIL PROTECTED]

Importing into an AutoIncrement field

I would like to avoid the necessity of specifying all of the fields - instead use the following syntax: INSERT INTO teachers VALUES (1,12345,NULL,'Harry','Smith','707-773-4523',2',... However, the first field is an autoincrementing field. Will MySQL ignore my value and overwrite it with the "aut

Using PHP to do a MySql Dump

Is there a function that can be implemented with PHP to do the equivalent of a mysqldump? Todd -- Ariste Software, Petaluma, CA 94952 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://li

Front end for MySQL databases

I have created a Web application for a client that uses MySQL for the DB. Most of my experience has envolved writing a front end in Delphi and using ODBC to give a client an ability to administer the DB (e.g. do queries to get lists, etc.). The application is written in PHP and I am curious what

"Calendar" database

I would like to get some suggestions for the structure of a sql "Calendar" database. My task is to create a "Calendar" of events in the San Francisco Bay Area. For instance, an event may be M-F 11:00 am, 3:30 pm, 7:30 pm and Sat 4:30 pm and 6:30 pm. Of course, there is a beginning date and en

Re: ODBC and TimeStamp

<<< Can you run the query from mysql interface? >>> Yes. Todd -- Todd Cary Ariste Software 2200 D Street Extension Petaluma, CA 94952 707-773-4523 [EMAIL PROTECTED] - Before posting, please check: ht

Re: ODBC and TimeStamp

* > * Want to meet other PHP developers * > * in your area? Check out: * > * http://php.meetup.com/* > * No developer is an island ... * > ***

Re: ODBC and TimeStamp

Patrick - I have the following Sql SELECT statement: SELECT FirstName, LastName, ChangeTime FROM Members; If I execute the statement using ADO (uses a ODBC connection), the result set is empty. When the ChangeTime is removed, I get a result set. Todd -- Todd Cary Ariste Software 2200 D

ODBC and TimeStamp

I have a MySQL TimeStamp in my table. If I try to do a query via ODBC, I get an error on the field. Any suggestions? Todd -- Todd Cary Ariste Software 2200 D Street Extension Petaluma, CA 94952 707-773-4523 [EMAIL PROTECTED

Significance of /*!32312 IF NOT EXISTS*/;

In my mysql dump of a DB using the -B switch, I get CREATE DATABASE /*!32312 IF NOT EXISTS*/ sfyc; What is the significance of /*!32312 IF NOT EXISTS*/ - the "/*!32312"? Isn't the statement commented out? With the CREATE TABLE, what happens if the table already exists? Tod

Moving a DB from one Server to another

Is there a quick and simple way to move a MySQL DB from one server to another MySQL server? Can I just copy the tables? Todd -- Todd Cary Ariste Software 2200 D Street Extension Petaluma, CA 94952 707-773-4523 [EMAIL PROTECTED

Re: Cannot set privileges

Thanks to Paul, I solved the problem by replacing the "*" with "*.*". In my "PHP and MySQL" book, the "*" is used in the examples. Any explanation why this does not work? Todd -- Todd Cary Ariste Software 2200 D Street Extension Petaluma

Cannot set privileges

Have I missed something here? Todd -- Todd Cary Ariste Software 2200 D Street Extension Petaluma, CA 94952 707-773-4523 [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://

Re: Installing mysqladmin

the default. I want a database in /home/sfyc. Todd -- Todd Cary Ariste Software 2200 D Street Extension Petaluma, CA 94952 707-773-4523 [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php

Installing mysqladmin

My platform is RH Linux and I did a rpm with rpm -i /tmp/MySQL-3.23.49a-1.i386.rpm I got back the acknowledgement and the suggestion that I change the root user password with /usr/bin/mysqladmin However, mysqladmin is not on the system!! What did I miss?? Todd -- Todd Cary Ariste Software

Re: Remote admin of MySQL from Win 2K

That was the answer and solution to my MySQL problem!! Many thanks Todd -- Todd Cary Ariste Software 2200 D Street Extension Petaluma, CA 94952 707-773-4523 [EMAIL PROTECTED] - Before posting, please check: http

Re: Remote admin of MySQL from Win 2K

YES! I was missing something: Telnet!! I can log in *BUT* I am unable to change the MySQL password. mysqladmin -h www.myhost.org -u root -p password 'new_password' asks me for the password and when I use the root password (su password), I get Access Denied. Todd -- Todd Cary Arist

Re: Remote admin of MySQL from Win 2K

list - not my business). Todd * This is the first time I have ever used MySQL and I am trying to see if I can around not being able to access Interbase (my usual DBMS). -- Todd Cary Ariste Software 2200 D Street Extension Petaluma, CA 94952 707-773-4523 [EMAIL

Re: Remote admin of MySQL from Win 2K

Told my client that dealing with Yahoo would have it's problems...they will not do anything to the server once they wipe the disk clean and install RaQ-4 :-) !! Thanks for the MySQL advice.. Todd -- Todd Cary Ariste Software 2200 D Street Extension Petaluma, CA 94952 707-773-4523 [

Re: Remote admin of MySQL from Win 2K

Just installed MySQL Manger...great! But I cannot get into a Cobalt RaQ-4 - problem due to my inability to be root since I can only admin the server by a Web page. H Todd -- Todd Cary Ariste Software 2200 D Street Extension Petaluma, CA 94952 707-773-4523 [EMAIL PROTECTED

Remote admin of MySQL from Win 2K

Is there an appl for administering MySQL on a remote Linux server from a Win 2K client? Todd -- Todd Cary Ariste Software 2200 D Street Extension Petaluma, CA 94952 707-773-4523 [EMAIL PROTECTED] - Before posting, please

Re: Socket trouble

Amy - See my message and the fix for mysql. Todd -- Todd Cary Ariste Software 2200 D Street Extension Petaluma, CA 94952 707-773-4523 [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the

Re: Socket problem connecting

There is not a my.cnf file on my system. How do I determine where mysql is looking for my.cnf so that I can create one in that location? Many thanks. Todd -- Todd Cary Ariste Software 2200 D Street Extension Petaluma, CA 94952 707-773-4523 [EMAIL PROT

Socket problem connecting

I am getting this message when I try to establish a connect to the DB. Any suggestions on where I can find an answer? Warning: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /var/www/html/mysql/php/connect.php on line 2 Todd -- Todd Cary Ariste

Re: Adding new users

Where is the user table? Can it be viewed? How can I tell what is in it with mysqladmin? Todd -- Todd Cary Ariste Software 2200 D Street Extension Petaluma, CA 94952 707-773-4523 [EMAIL PROTECTED] - Before posting, please

Re: Adding new users

h Interbase, it is port 3050. Warning: Can't connect to MySQL server on '209.204.172.137' (110) in /var/www/html/mysql/php/connect.php on line 2 Todd -- Todd Cary Ariste Software 2200 D Street Extension Petaluma, CA 94952 707-773-4523 [EMAIL PROTECTED] Egor Egorov wrote: > Todd

Re: Adding new users

Whps! I am using PHP on a Linux platform. Todd -- Todd Cary Ariste Software 2200 D Street Extension Petaluma, CA 94952 707-773-4523 [EMAIL PROTECTED] Georg Richter wrote: > On Monday, 13. May 2002 07:06, Todd Cary wrote: > Hi, > > > However this does not w

Adding new users

1) Can I add new users with mysqladmin? 2) With mysqladmin as root I can get a response to # /usr/bin/mysqladmin -pmypassword ping However this does not work in a script: mysql_connect("209.204.172.122", "root", "mypassword"); What am I missing? Todd -- To

Re: [Newbie] Connecting for the first time

that my questions are really going to be basic!! Todd -- Todd Cary Ariste Software 2200 D Street Extension Petaluma, CA 94952 707-773-4523 [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php

[Newbie] Connecting for the first time

quot;"); if ($link) { print("Connected"); } else { print("Cannot connect"); } ?> Connection form Trying to connect to a MySQL DB -- Todd Cary Ariste Software 2200 D Street Extension

What does this message mean

I am receiving this message from MySQL: +++ Sorry. Your message could not be delivered to: w3d3demo (Mailbox or Conference is full.) +++ What am I missing? Todd -- Dr. Todd Cary Ariste Software 2200 D Street Extension Petaluma, CA 94952 707-773-4523 [EMAIL PROTECTED

DDL and MySQL

? With Interbase it is "gdb". Many thanks... Todd -- Dr. Todd Cary Ariste Software 2200 D Street Extension Petaluma, CA 94952 707-773-4523 [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/

Best book on MySQL

I need to convert a PHP app from using Interbase to using MySQL. What is the best book? Todd -- Todd Cary Ariste Software 2200 D Street Extension Petaluma, CA 94952 707-773-4523 [EMAIL PROTECTED] - Before posting, please

Re: Remote Connection to Linux MySQL

Your problem is probably due to not having a grant entrry in the user table that allows your user name to log in from 192.168.1.253. Try GRANTing either that IP, or all IP's (%) access with that user name. This link should help you out. http://www.mysql.com/doc/G/R/GRANT.html Cary

Re: A stupid question...

what your looking for. If you could elaborate a little I am sure that one of us could help you out. Cary - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

Re: what's wrong with EXPLAIN?

I am probably wrong, but my assumption was that EXPLAIN was used to help optimize SELECT statements, not INSERT/UPDATE statements. So if I am thinking correctly (this time :-), EXPALAIN is erroring for you because it only deals with SELECT statements. Cary At 12:10 PM 3/9/02, savaidis wrote

Re: Explain this Explain ?

I was playing with. I'm assuming it is EXPLAIN's response to a not so useful SELECT statement, but thought I would ask just to be sure. I'm one of those anal people that sit here and try queries all day before putting them into a routine. Trying to use the EXPLAIN f

Explain this Explain ?

IN SELECT COUNT(updated = 0) FROM tbl_produpdate I couldn't find anything like this in my MySQL book or in the on line help. Thanks, Cary - Before posting, please check: http://www.mysql.com/manual.php (the manual) ht

Re: W2K Network

I'm running on almost the same setup as you, only using VFP as my frontend app. Try setting up a User DSN on the client machines instead of a system DSN. This might not be causing the problem, but setting it up this way works great for me. Cary At 02:31 PM 2/13/02, Otto Saayman wrote

Re: dumping between tables?

ar on this page. http://www.mysql.com/doc/m/y/mysqldump.html Cary query >I was considerign using mysqldump, but I only want to reload one table in >a database, and I'm not sure the mysqldump syntax for specific tabl

Re: dumping between tables?

ar on this page. http://www.mysql.com/doc/m/y/mysqldump.html Cary query >I was considerign using mysqldump, but I only want to reload one table in >a database, and I'm not sure the mysqldump syntax for specific tabl

Re: NOT insert existing record

You might try something like this.(unless I am missing something:-) $result = mysql_query ("select * from email2 where email = $email"); if (mysql_num_rows($result)) { } else {} Cary At 07:28 AM 1/28/02, [EMAIL PROTECTED] wrote: >I have a ta

replication

erver-id = 2 master-host = 64.64.51.104 master-user = repl master-password = blahblah master-port = 3306 I've tried everything I can think of. Any help would be most appreciated! Cary -- Cary Collett [EMAIL PROTECTED] http://c