Re: User/Password for every host?

Miguel Cardenas wrote: Hello list I have a doubt... Do I need to set a password to a user for each host the user has permission to connect from? To mysql, a user is '[EMAIL PROTECTED]'. That is, [EMAIL PROTECTED] and [EMAIL PROTECTED] are two different users from mysql's point of view. You

User/Password for every host?

Hello list I have a doubt... Do I need to set a password to a user for each host the user has permission to connect from? Let's supose // add user 'somebody' GRANT ALL PRIVILEGES ON *.* TO somebody@"192.168.0.%" IDENTIFIED BY 'onepass'; if I want 'somebody' to have access from "dsl-A.B.C.D-pro

Re: restore db from mysqldump I get different databases size

2005/10/1, Lorenzo Sicilia <[EMAIL PROTECTED]>: > Hi to all, > > I have a database online with innodb &myisam tables. I use this option when I > do a daily backup: > #mysqldump -c -e -Q -u --lock-tables --flush-logs --opt myDB -u MyUser -p > > db.sq > > when I restore my db with this command: > # m

Re: config diff: query time went from 70 mins to 20 seconds

On 10/1/05, David Sparks <[EMAIL PROTECTED]> wrote: > So what was the setting below that was tanking mysql performance? I > suspect that "innodb_log_buffer_size=32M" was the culprit. I think that tripling your buffer pool did the job. :) Also I'd revert innodb_additional_mem_pool_size and innodb_

Re: float size?

At 13:00 -0400 10/1/05, Jerry Swanson wrote: I have field in database type "float". When I insert number like 12345.27 , number is inserted 12345.3 Why it happened? Rounding. What is the exact data type of the column? -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB,

float size?

I have field in database type "float". When I insert number like 12345.27 , number is inserted 12345.3 Why it happened?

Re: config diff: query time went from 70 mins to 20 seconds

On 10/1/05, David Sparks <[EMAIL PROTECTED]> wrote: > Here is a config diff that made mysql usable again. As the database > grew in size, buffer sizes in the config were increased to try to boost > mysql performance. > > Unfortunately it didn't work as expected. As the config was tweaked, > mysql

restore db from mysqldump I get different databases size

Hi to all, I have a database online with innodb &myisam tables. I use this option when I do a daily backup: #mysqldump -c -e -Q -u --lock-tables --flush-logs --opt myDB -u MyUser -p > db.sq when I restore my db with this command: # mysql -u root -p -D myDB_restored < db.sql I get a new databse

Re: Mysql Regular expression

2005/10/1, Binay(Local) <[EMAIL PROTECTED]>: > Hi > > Can any body tell me how to strip all the html characters from a text column > while querying? > MySQL can't do it for you, you'll have to program it at your application level. (PHP has strip_tags, Perl and QT have regular expression ) > > Th

Re: timing queries?

Jacek Becla wrote: Hi, Does anyone know how to execute SQL statements from a text file such that the summaries "X rows in set (X.YZ sec)" are printed for each query? Neither of these do it: mysql < batch-file mysql -e 'source batch-file' If you add verbosity using the parameter -vv (or -v

RE: timing queries?

If you use source absolute-pathname from mysql command prompt, then it will execute each statement(or line) in the file individually and print the results exactly in the format you are looking for. sujay -Original Message- From: Jacek Becla [mailto:[EMAIL PROTECTED] Sent: Saturday, Octo

Mysql Regular expression

Hi Can any body tell me how to strip all the html characters from a text column while querying? Thanks Binay

How to call C API functions from MS Access ?

Hi List, I want to call the C API functions from Visual Basic in MS Access 2003. I assume that I have to use: "c:\Program Files\MySQL\MySQL Server 4.1\Bin\LibMySQL.dll". In my code at module level I have included various code lines to declare entry-points, such as: Declare Function mysql_info Li