Mysql user

Hi all, Can any one tell me the command to list all mysql users ??? Thanks in advance Binay

Mysql user

Hi all, Can any one tell me the command to list all mysql users ??? Thanks in advance Binay

RE: Mysql user

Hi Binay, Use the mysql client to open the mysql database. For example, enter the following at the mysql prompt: use mysql Then type: select * from user; Bob -Original Message- From: Binay [mailto:[EMAIL PROTECTED] Sent: Friday, December 05, 2003 12:26 AM To: mysql users Subject:

Re: Large data set load and access

[EMAIL PROTECTED] wrote: Thanks for the heads up on this. Unfortunately the only varchar is the gbl_locus field, so I'm not sure how much this would by me for the space. Thanks again, Brad Eacker ([EMAIL PROTECTED]) No, it wouldn't save you any space.

Re: Licence question

Ivan Cukic wrote: 1. Free use for those who are 100% GPL 2. Free use for those who never copy, modify or distribute 3. Commercial use for everyone else Strange thing: How can SUSE redistribute mySQL when it is not 100% GPL? (It has MPL, ... also, beside commercial programs) Ivan -- MySQL

Re: Mysql user

Binay wrote: Hi all, Can any one tell me the command to list all mysql users ??? Thanks in advance Binay use mysql; select User from user; Ivan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Importing data

Hi all, How can i import table structure and data which is there in a text file to database say test_database using phpmyadmin. I m asking using phpMyadmin as i don have shell access and hence can't use mysql commands. Plz help me ... its very urgent .. Thanks in advance Binay

Re: Installation Problem

Hi. Thanks for the prompt reply. It seems strange that the installation procedure should include an instruction that requires a password with no indication that one is required (i.e. there is no -p in the command sequence). Reading through Mark Liyanage's installation instructions, I notice

4.1.0 - 4.1.1 = Unknown character set: 'latin1_swedish_ci'

I have upgraded from MySQL (rpm) 4.1.0 to 4.1.1 and now I see lots of lines in the error log with: Unknown character set: 'latin1_swedish_ci' How can I fix this? Regards Jacob -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

setting values to default w/ null

hi i'm trying to get musql to insert the default values into a table. from the insert section in the manual: Warnings can occur under any of the following conditions: * Inserting NULL into a column that has been declared NOT NULL. The column is set to the default value appropriate for the

DELETE on a huge table; how long *should* it take?

Hello, I have quite a large table, 45 million rows, which has 3 indexes on it. The rows are evenly distributed across one particular index, which records the time the row was inserted. At any given time there's between 20 and 21 days worth of rows, and every night I delete anything over 20 days.

Subquery ( show columns from...)

Hi all, I was wondering is it possible to use SHOW COLUMNS FROM tbl_name as a subquery. I tried something like this ( w/o success ): SELECT * FROM tbl1 INNER JOIN (SHOW COLUMNS FROM tbl2) AS t2 WHERE t1.ID =t2.field; or SELECT field FROM (show columns from Research.idefix); Teemu --

Optimization on query with WHERE, GROUP BY and ORDER BY

Hi, I have a table with about 500 000 rows and need to execute a query with first a WHERE then a GROUP BY and then ORDER BY all on different columns is their any way to optimize this? The table can look something like this: row_id INT PRIMARY KEY where_column SET('a','b','c') groupby_column

Re: Optimization on query with WHERE, GROUP BY and ORDER BY

Hello, On Fri, Dec 05, 2003 at 12:02:05PM +0100, Martin Gillstr?m wrote: The table can look something like this: row_id INT PRIMARY KEY where_column SET('a','b','c') groupby_column VARCHAR(255) orderby_column DATE .. more rows that I need to fetch with the select. This is what I have

MySQL 4.1.1 is released

For those who are interested like me: MySQL 4.1.1 is released. Thanks, __ NZEYIMANA Emery Fabrice NEFA Computing Services, Inc. P.O. Box 5078 Kigali Office Phone: +250-51 11 06 Office Fax: +250-50 15 19 Mobile: +250-08517768 Email: [EMAIL PROTECTED]

RE: Importing data

[snip] How can i import table structure and data which is there in a text file to database say test_database using phpmyadmin. I m asking using phpMyadmin as i don have shell access and hence can't use mysql commands. [/snip] What format is the table structure in? As for the data it should be

Re: Subquery ( show columns from...)

Teemu Kuulasmaa [EMAIL PROTECTED] wrote: I was wondering is it possible to use SHOW COLUMNS FROM tbl_name as a subquery. I tried something like this ( w/o success ): SELECT * FROM tbl1 INNER JOIN (SHOW COLUMNS FROM tbl2) AS t2 WHERE t1.ID =t2.field; or SELECT field FROM (show

Where to find MySQL-shared-compat-VERSION.i386.rpm ?

Hello, Please forgive me my newbee-question: Where can I find MySQL-shared-compat-VERSION.i386.rpm ? I have just installed MySQL 4.0 and an application requests libmysqlclient.so.10 Franz -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

RE: Tree-like structure: make it simply

how about recreating the table w/o the autoincrement, then reload the data, then alter table to reimplement the autoincrement? -Original Message- From: Matthew [mailto:[EMAIL PROTECTED] Sent: Thursday, December 04, 2003 7:12 PM To: Alex E.Wintermann; [EMAIL PROTECTED] Subject: Re:

Re: Where to find MySQL-shared-compat-VERSION.i386.rpm ?

Look at http://www.mysql.com/downloads/mysql-4.0.html for Dynamic client libraries for your platform. Enjoy Nitin - Original Message - From: Franz Edler [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, December 05, 2003 6:25 PM Subject: Where to find

Re: DELETE on a huge table; how long *should* it take?

Hi, You can do it in several smaller and faster deletes using the LIMIT option - for example DELETE QUICK from table WHERE indexed_row UNIX_TIMESTAMP()-86400 limit 1; HTH Dobromir Velev [EMAIL PROTECTED] - Original Message - From: Chris Elsworth [EMAIL PROTECTED] To: [EMAIL

RE: [OT] RE: New Microsoft Critical Patch

Furthermore, Microsoft will *not* email you about real critical updates either. The only way to get an email from Microsoft is to request support or to sign up for a mailing list. That's something they bring up at just about every Microsoft seminar these days. Thanks, Rob Brahier Web

Optimizing and repair impact

We have a database that supports our customers and runs pretty much 24/7/365. Obviously we need to keep this database healthy and optimized. I've read the official documentation and third party books on MySQL and they all are very good at explaining what should be done and how to do it but none

Re: fulltext search speed issue with SQL_CALC_FOUND_ROWS

Hi! On Dec 04, tk wrote: Hello, Thanks for the response. There is one thing that is not clear however. Regardless of whether or not I perform the fulltext search with or without the SQL_CALC_FOUND_ROWS keyword, the results that I get are exactly the same. Also, the notion of

RE: fulltext search speed issue with SQL_CALC_FOUND_ROWS

Hi TK, There was an optimizer bug in MySQL 4.0 This bug is fixed in 4.0.17 (not yet released) # Fixed bug when the optimiser did not # take SQL_CALC_FOUND_ROWS into account # if LIMIT clause was present. (Bug #1274) Kind regards Gunnar -Original Message- From: [EMAIL PROTECTED]

Need help with query. Please!

I have the following 3 tables: table 1: companies fields 1: company_id, company name, status Sample data: 1 , company 1 , 0 2 , company 2 , 1 3 , company 3 , 1 4 , company 4 , 0 5 , company 5 , 1 table 2: groups fields 2: group_id, group_name Sample data: 1 , Group 1 2 , Group 2 3 , Group 3 4 ,

Relationships

How do I create relationships between tables? I have tried but have no way of being sure that I am successful just by looking at the db. I am not sure how to relate one record in one table to it corresponding record in another. Mat -- MySQL General Mailing List For list archives:

invalid compressed data ?

I am trying to untar the .gz but this is what I get. #tar xzvf mysql-standard-4.0.16-pc-linux-i686.tar.gz mysql-standard-4.0.16-pc-linux-i686/ mysql-standard-4.0.16-pc-linux-i686/bin/ mysql-standard-4.0.16-pc-linux-i686/bin/comp_err mysql-standard-4.0.16-pc-linux-i686/bin/replace

Re: fulltext search speed issue with SQL_CALC_FOUND_ROWS

Hello Sergei, Gunnar, and others, thank you for your quick responses. One little mystery remains: Why does one need to read all the row data (with SQL_CALC_FOUND_ROWS) to get the total number of results when using a limit? When the index is used to find relevant rows and sort the results, the

Re: 4.1.0 - 4.1.1 = Unknown character set: 'latin1_swedish_ci'

Jacob Friis Larsen [EMAIL PROTECTED] wrote: I have upgraded from MySQL (rpm) 4.1.0 to 4.1.1 and now I see lots of lines in the error log with: Unknown character set: 'latin1_swedish_ci' How can I fix this? Does 'latin1_swedish_ci' present in the output of SHOW COLLATION LIKE 'latin1%'?

Re: Lost connection to MySQL server during query - pls help

At 14:14 5/12/2003 +0800, Kiky wrote: Hi Guys, I have a problem with Error 2013 - Lost connection to MySQL server during query I'm using mysql 3.23.41 under Linux Mandrake, and mysql 4.0.15 under Win XP Pro. They turn out to have the same error. Please upgrade you MySQL Windows client to 4.0.16

RE: MySQL 4.1.1 has been released

Hallo Lenz, From: Lenz Grimmer [mailto:[EMAIL PROTECTED] Any chance to offer binaries for PowerPC Linux as well ? (Preferable tgz) Yes, we plan to offer Linux/PPC binaries in the near future - we're currently working on purchasing a system for that. If you have some harddisk space

Re: Need help with query. Please!

Try: SELECT C.company_id, C.company_name FROM companies C LEFT JOIN company_group_intersect CG ON (C.company_id=CG.company_id AND CG.group_id='1') WHERE C.status='1' AND CG.company_id IS NULL -- Diana Soares On Fri, 2003-12-05 at 15:08, Robert Hughes wrote: I have the following 3 tables:

Re[2]: Tree-like structure: make it simply

Hello Matthew, Friday, December 5, 2003, 2:12:08 AM, you wrote: thanks, but some more see below. [skipped] I have some table: /* BEGIN DUMP */ CREATE TABLE `sp_tovar_vid` ( `id` int(11) NOT NULL auto_increment, `id_tovar_vid` int(11) NOT

RE: Need help with query. Please!

That worked perfectly!!! Thanks so much :-) -Original Message- From: Diana Soares [mailto:[EMAIL PROTECTED] Sent: Friday, December 05, 2003 10:31 AM To: Robert Hughes Cc: [EMAIL PROTECTED] Subject: Re: Need help with query. Please! Try: SELECT C.company_id, C.company_name FROM

RE: Lost connection to MySQL server during query - pls help

[snip] Please upgrade you MySQL Windows client to 4.0.16 there is a bug with net_read_timeout and net_write_timeout on 4.0.15 that disconnect when the query takes more than 30 secons. [/snip] Can you elaborate on this, we have not seen this problem -- MySQL General Mailing List For list

Re: Lost connection to MySQL server during query - pls help

Kiky [EMAIL PROTECTED] wrote: I have a problem with Error 2013 - Lost connection to MySQL server during query I'm using mysql 3.23.41 under Linux Mandrake, and mysql 4.0.15 under Win XP Pro. They turn out to have the same error. My problem is: I have a Java program which is actually a

Database Internals Engineer opportunity

Outstanding opportunity for someone in the San Diego area. Database Internals Engineer Successful candidate will be responsible for the architecture, design and implementation of a database engine and its interface with a variety of commercial databases. Responsibilities include authoring

RE: Lost connection to MySQL server during query - pls help

At 10:44 -0600 12/5/03, Jay Blanchard wrote: [snip] Please upgrade you MySQL Windows client to 4.0.16 there is a bug with net_read_timeout and net_write_timeout on 4.0.15 that disconnect when the query takes more than 30 secons. [/snip] Can you elaborate on this, we have not seen this problem See

Named Pipe crashes on MySQL (4.1.1 alpha) WinXP

At 19:04 4/12/2003 -0600, Matt W wrote: Hi, Named Pipe crashes on MySQL (4.1.1 alpha) WinXPI have been unable to get named pipes to work on mysqld-nt 4.1.1 Alpha(including today's official release). As soon as I attempt a connect the server crashes. I can't create a debug trace because named pipes

Re: Replication

Stefan: Thank you very much, I got the point. I'll make some tests with the 'log-slave-updates' parameter, I think if the master can log the updates made from any slave, then it can propagate the changes to the others. Regards From: Stefan Kuhn [EMAIL PROTECTED] Reply-To: [EMAIL

Re: Installation Problem

Alex Brown wrote: Hi. Thanks for the prompt reply. It seems strange that the installation procedure should include an instruction that requires a password with no indication that one is required (i.e. there is no -p in the command sequence). Reading through Mark Liyanage's installation

How do I convert MDF (MS SQL) to MySQL w/o having MS SQL?

I run a website using MySQL, PHP, and CFMX. Someone recently gave a data file to me that they'd like to access. The problem is that it appears to be from MS SQL. How can I convert/import this into MySQL? I did some searching and found MSSQL-to-MySQL, but this program requires that I have MSSQL

Re: How do I convert MDF (MS SQL) to MySQL w/o having MS SQL?

there is a command but i didnt found it in the documentation. Try dump MS SQL database into a text file and then try mysqlimport. --- Mark Graves [EMAIL PROTECTED] wrote: I run a website using MySQL, PHP, and CFMX. Someone recently gave a data file to me that they'd like to access. The

Re: How do I convert MDF (MS SQL) to MySQL w/o having MS SQL?

..I don't have MSSQL Zenzo [EMAIL PROTECTED] 12/5/2003 2:30:44 PM there is a command but i didnt found it in the documentation. Try dump MS SQL database into a text file and then try mysqlimport. --- Mark Graves [EMAIL PROTECTED] wrote: I run a website using MySQL, PHP, and CFMX. Someone

RE: How do I convert MDF (MS SQL) to MySQL w/o having MS SQL?

Ask the person who gave you the file to do the work. Give them a list of formats you can read (i.e. SQL, csv, etc.) and let them decide which of those formats they want to export into. John -Original Message- From: Mark Graves [mailto:[EMAIL PROTECTED] Sent: Friday, December 05, 2003

RE: How do I convert MDF (MS SQL) to MySQL w/o having MS SQL?

Do you only have the Microsoft DBF and ldf files? -Original Message- From: Mark Graves [mailto:[EMAIL PROTECTED] Sent: Friday, December 05, 2003 1:24 PM To: [EMAIL PROTECTED] Subject: How do I convert MDF (MS SQL) to MySQL w/o having MS SQL? I run a website using MySQL, PHP, and CFMX.

replication question

Greetings, Firstly I have searched the archives and received exactly 0 results returned for 'START SLAVE 1064' so... I have a mysql server I wish to replicate, its running 3.23.54. I have two test FreeBSD 5.1 servers I installed and from ports version 3.23.58. I completed the following steps

RE: replication question

Try slave start -Original Message- From: Andrew Hall [mailto:[EMAIL PROTECTED] Sent: Friday, December 05, 2003 2:46 PM To: [EMAIL PROTECTED] Subject: replication question Greetings, Firstly I have searched the archives and received exactly 0 results returned for 'START SLAVE 1064'

RE: replication question

DUH!! I should have tried that... Thank you! Drew On Fri, 2003-12-05 at 15:49, Victor Pendleton wrote: Try slave start -Original Message- From: Andrew Hall [mailto:[EMAIL PROTECTED] Sent: Friday, December 05, 2003 2:46 PM To: [EMAIL PROTECTED] Subject: replication question

Installation ERRORS MySql 3.23.51

I came across the following errors after install I am not able to start server from terminal (only progress i made was running as root NOT user) 1. ERROR: 1062 Duplicate entry 'localhost-root' for key 1 ERROR: 1062 Duplicate entry 'localhost-root' for key 1 2. WARNING: The host 'localhost' could

how to add a new user to the users table, with out having grant options

Hi, I have a password to a database with all the databse privileges, except reload, shutdown, process, file and with Grant options. This is the administrator or super user password, with most of the privileges. Someone else has created the data base. Now I'll maintain it. I need to add a new

[Fwd: RE: replication question]

Didn't have the list cc-ed. -Forwarded Message- From: Andrew Hall [EMAIL PROTECTED] To: Mike Johnson [EMAIL PROTECTED] Subject: RE: replication question Date: Fri, 05 Dec 2003 16:17:14 -0500 Ok, at this point it appears my replication is working, but I have two questions:

MAC OS X installation problem

A newbie here, with a simple question (I guess). I just installed MySQL on my OS X 10.2 But failed pretty quick. Please help me... I wanna get started. This it what it looks like after following the description in the ReadMe file. Last login: Fri Dec 5 22:41:28 on ttyp1 Welcome to Darwin!

What is code and what's not?

I found a script on this help page, that should be used when giving the root user a password, but I really don't understand what of this is words and what is just an example. /usr/local/mysql/bin/mysqladmin -u root password password /usr/local/mysql/bin/mysqladmin -u root -h `hostname` password

with-openssl failing?

I compiled MySQL 4.1.1 --with-openssl --with-vio and when I look at the variables with mysqladmin, has_openssl is set to NO. What could have happened to cause this? I've got OpenSSL 0.9.7c installed. I'm seeing this on both Solaris and Debian hosts. I'm not seeing any errors during the

Re: What is code and what's not?

Swedish should not be a problem ... the chief software architect behind MySQL is a Swedish-speaking Finn. If you want the password to be bubba, then the syntax is: /usr/local/mysql/bin/mysqladmin -u root password bubba If the computer (host) name is snickers, it would be written as:

can't seem to reset password

I have been reading and following the instructions from: http://www.mysql.com/doc/en/Resetting_permissions.html But, if I do: ./bin/mysqld_safe --skip-grant-tables And then I: mysqladmin -u root password 'mypassword' I get: mysqladmin: unable to change password; error: 'You must have privileges

How to find my directory?

I've read a lot of tips (even if I'm not up and running yet) about telling people to setup the correct way to their mysql directory. So, what I wanna know (when I get there) is if there is any command that I can write to make the computer tell where this files actually are?

How to find my directory?

I've read a lot of tips (even if I'm not up and running yet) about telling people to setup the correct way to their mysql directory. So, what I wanna know (when I get there) is if there is any command that I can write to make the computer tell where this files actually are?

Re: fulltext search speed issue with SQL_CALC_FOUND_ROWS

Hi! On Dec 05, tk wrote: Hello Sergei, Gunnar, and others, thank you for your quick responses. One little mystery remains: Why does one need to read all the row data (with SQL_CALC_FOUND_ROWS) to get the total number of results when using a limit? When the index is used to find

MyODBC errors

Mysqlians, I am getting the following errors in an application log for 4.0.16 mysql and 3.51 myODBC SQL Error: SQLSTATE=S0002 Native error=1146 '[unixODBC][MySQL][ODBC 3.51 Driver][mysqld-4.0.16-Max-log]Table 'TRIBE.NETWORK_VECTOR' doesn't exist' SQL Error: SQLSTATE=S1000

MySQLHotCopy - No tables to hot-copy HUH?!

I have a problem using mysqlhotcopy. Everything was fine until I recently moved to a different server. Old one was running mysql 4.0.15 on FreeBSD 4.8, new is mysql 4.0.16 on FreeBSD 4.9. The error returned is No tables to hot-copy at /usr/local/bin/mysqlhotcopy line 379. I ran w/ --debug and

problem using MySQL++ API

hello, I am using mysql++ API and it is giving an error - The procedure entry point mysql_connect could not be located in the dynamic link library LIBMYSQL.dll any solutions, Best Regards - Pawan Have A Nice Day

Re: odbc 3.51.06

dear mysql team, i was trying to save a file in mysql now can u please help me with an alternative that i save the file name in the database and how to retrieve back prathima rao - Original Message - From: Prathima Rao To: [EMAIL PROTECTED] Sent: 06/12/2003 9:23 AM

Character escaping

I have searched the archives for a solution to my problem and also the FAQ and the mysql documentation but can't seem to resolve it. I am exporting a tab delimited file from FileMaker Pro 5.5 using Mac OS 10.3. I am uploading the file to my hosted server running RedHat Linux 7.2. I am then