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: Confused about privileges

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, todd cannot access sfyc with mysql -u todd -p sfyc And the mysql

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: Blew MySQL away by accident

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

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]

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

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

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 give yo

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 -- inline: NewLogo.gif

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]

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 following:

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 logging o

Re: Granting privileges

tion; 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 indentified by 'my_password' - with grant option; I then log ou

Re: Granting privileges

I did some experimenting and here is what I found: grant all - on * - to bugsbunny indentified by 'bugs - with grant option; After putting the above into MySQL as root, I signed on as "todd" with the appropriate PW and tried to get into mysql with mysql -u bugsbunny -p [using bugs as

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

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

div class=moz-text-flowed style=font-family: -moz-fixedI 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.

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)

Front end for MySQL databases

div class=moz-text-flowed style=font-family: -moz-fixedI 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.).

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

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

Re: ODBC and TimeStamp

/* * No developer is an island ... * * -- Todd Cary Ariste Software 2200 D Street Extension Petaluma, CA 94952 707-773-4523 [EMAIL PROTECTED] - Before posting, please check

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: http://www.mysql.com

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? Todd -- Todd Cary

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

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: 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

Cannot set privileges

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://lists.mysql.com

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, CA 94952 707-773-4523 [EMAIL PROTECTED

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 Ariste Software

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 PROTECTED

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

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: 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

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 [EMAIL

Re: Remote admin of MySQL from Win 2K

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 PROTECTED

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 Software 2200 D

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 work in a script

Re: Adding new users

. Could that be true? I check my router and see if it has port 110 open - with 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

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

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 -- Todd Cary Ariste Software 2200 D Street

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

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/manual.php

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

[Newbie] Connecting for the first time

, ); if ($link) { print(Connectedbr); } else { print(Cannot connectbr); } ? html head titleConnection form/title /head body Trying to connect to a MySQL DB /body /html -- Todd Cary Ariste Software 2200 D Street Extension Petaluma, CA 94952 707-773-4523 [EMAIL PROTECTED

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