Re: Regarding MySQL to set new seed value

2003-07-02 Thread Nils Valentin
2003 7 2 22:57Sibananda Sahoo : Dear Sir Hope you to be fine. I know MS SQL supports the following query to reseed the seed value: DBCC CHECKIDENT ('tablename',RESEED,new-seed-value); Is there any support like the above in MySQL 4.0.13 to set new seed value ? Awaiting your reply.

Re: The file /usr/local/mysql/libexec/mysqld doesn't exist or is not executable

2003-07-02 Thread Todd O'Bryan
I think mysqld_safe is just a shell script, so you might be able to go through there and see if you can find where /usr/local/mysql is defined. On the other hand, I just looked, and it looks like it's smart enough to figure out if you've moved the installation directory. Try cd-ing to the

Re: MySQL Password

2003-07-02 Thread Nils Valentin
Hi Victoria, 2003 7 2 22:05Victoria Reznichenko : Nils Valentin [EMAIL PROTECTED] wrote: Hi Victoria, I enclose a sample. http://www.mysql.com/doc/en/Resetting_permissions.html ... 2. Restart mysqld with the --skip-grant-tables option. ... How would you understand this ?

Re: Table Name as UserName with a Blank Password

2003-07-02 Thread Nils Valentin
Hi Dan, By default 2 anonymous user accounts are setup in the mysql database. You will have to delete them first. you should find that you can login with any name (except the specified ones) without password. This will probably allow you to view the databases f.e. with SHOW DATABASES;, but

Re: Table Name as UserName with a Blank Password

2003-07-02 Thread Nils Valentin
2003 7 3 11:30Nils Valentin : Hi Dan, By default 2 anonymous user accounts are setup in the mysql database. You will have to delete them first. you should find that you can login with any name (except the specified ones) without password. This will probably allow you to view the databases

Re: Problem with mysqlimport.

2003-07-02 Thread Paul DuBois
At 14:18 +0100 7/2/03, Idries Hamadi wrote: Hi all, I've just started using mysql and I'm sure that my all problems are something todo with my oracle-ness, so please bear with me if I use case-insensitive table names or somthing ;) Ok. I've been using the mysql interactive command-line interface

Re: Upgrading MySQL on RedHat 9

2003-07-02 Thread Paul DuBois
At 11:33 -0400 7/2/03, Andrew Pierce wrote: I am getting ready to try to upgrade MySQL on my RedHat 9 box. I want to go from the version that came with the distro (version 3.23.54) to the latest (verion 4.0). Just thought I'd post to get a heads-up on any known issues or prerequisites. I just hate

Re: privileges not updating

2003-07-02 Thread Paul DuBois
At 14:03 -0400 7/2/03, me wrote: On Wednesday, July 2, 2003, at 04:42 AM, Victoria Reznichenko wrote: me [EMAIL PROTECTED] wrote: i have a strange thing going on - i'm trying to update privileges on some databases but it doesn't happened - even after flush privileges - according to the manual the

Re: The file /usr/local/mysql/libexec/mysqld doesn't exist or is not executable

2003-07-02 Thread Aleksandr Zingorenko
In general, you can simply search for the location of mysqld (perhaps using a utility like find). Once you find the file, make sure that it has execute permissions. Then, run mysqld_safe from the directory containing mysqld, as the error message suggests. - Original Message - From:

RE: Newbie SELECT problem

2003-07-02 Thread Creative Solutions New Media
Hello Peter, I agree I don't seem to be explaining what I want properly. Let me offer some data: (hopefully this will come out ok in the message). hitID sessionID userID timedatepageName 251 2917000 3591528 6:22:17 2003-7-2News Section 250 2917000 3591528

RE: The file /usr/local/mysql/libexec/mysqld doesn't exist or is not executable

2003-07-02 Thread Paul DuBois
At 20:57 -0400 7/2/03, [EMAIL PROTECTED] wrote: Todd, It didn't help. Here is the message: $ cd /usr/local/mysql $ ./bin/mysqld_safe The file /usr/local/mysql/libexec/mysqld doesn't exist or is not executable Please do a cd to the mysql installation directory and restart this

Re: Regarding MySQL to set new seed value

2003-07-02 Thread Nils Valentin
Dear Sibanada, You keep sending e-mails offlist directly to me. Are you aware that it might be much more beneficial for you to send a support request to the mysql mailing list ? I might not be available to answer always, but in such a case another person might answer you perhaps quicker and

Re: License?

2003-07-02 Thread Joel Rees
IANAL but IIRC publishing means to create a copy of something on a medium and distribution means to deliver that medium to someone else. IAANAL, but IIRC publishing means to place a work in a public place, ergo, for people to view, hear, or otherwise become an audience or witness to. Roughly

Re: OS X downloads

2003-07-02 Thread Joel Rees
There are two sets of binary downloads at mysql.com for Mac OS X. They're different sizes, but both say OS 10.2. Is that a typo? Is one of the two for OS 10.1, and could I have downloaded the wrong one and could that be the reason I can't get mysql to start? Todd I think the word,

<    1   2