RE: Allowing Connections From Remote Clients

The text of the error message means that this is not a possible cause; the error message given is coming from the mysql server itself after failed authentication -- in this case there's no matching u...@host combination. -Original Message- From: Michael Satterwhite [mailto:mich...@weblo

RE: How to become a DBA on MySQL

Sorry, I wish I did. I've used courses at lvsonline.com for all kinds of things (programming, graphics, etc.), but I didn't see anything about MySQL DBA. All of the courses I took there were good. They all had lab work that you submitted to the instructor. DBA might not lend itself to that. R

Re: How to become a DBA on MySQL

Oreilly <%20http://www.oreillyschool.com/?73235> (the people who host the MySQL Conference & Expo) run the Oreilly School of Technology<%20http://www.oreillyschool.com/?73235%20>and do online MySQL DBA courses at reasonable prices. Not sure if its still valid but you used to be able to get an extr

RE: finding exact query being run

Well, you should be using a wrapper around your DB library class already right? Like you don't use PEAR:DB directly, you have a wrapper class to handle making a connection, doing the query, handling the error, etc. Otherwise you're wasting a LOT of code/time. Not to mention it makes it trivial to s

RE: How to become a DBA on MySQL

Jerry, Do you know of any reputable online classes that you could point me to? Keith On Tue, 2010-07-13 at 14:25 -0400, Jerry Schwartz wrote: > You might want to see if there are any online classes that could get you > started. I usually start by reading a big, thick book -- but I've found that

Re: Allowing Connections From Remote Clients

On Tuesday, July 13, 2010 02:25:33 pm Prabhat Kumar wrote: > GRANT ALL PRIVILEGES ON **.** TO username@'tuna.iamghost.com' IDENTIFIED BY > PASSWORD 'password'; > > **.** ie for all databases , if want on particular DB > > GRANT ALL PRIVILEGES ON *MyDATABASE.** TO username@'tuna.iamghost.com' > ID

Re: Allowing Connections From Remote Clients

GRANT ALL PRIVILEGES ON **.** TO username@'tuna.iamghost.com' IDENTIFIED BY PASSWORD 'password'; **.** ie for all databases , if want on particular DB GRANT ALL PRIVILEGES ON *MyDATABASE.** TO username@'tuna.iamghost.com' IDENTIFIED BY PASSWORD 'password';; On Wed, Jul 14, 2010 at 12:44 AM, Carl

Re: How to become a DBA on MySQL

there is another suggestion. if you have good/unlimited net connection. Just explore youtube for MySQL videos.. I remember in my beginning days it helped me a lot. On Tue, Jul 13, 2010 at 11:56 PM, Shawn Green (MySQL) < shawn.l.gr...@oracle.com> wrote: > On 7/13/2010 9:24 AM, alba.albetti wrote:

Allowing Connections From Remote Clients

I am trying to connect to MySQL server [192.168.0.100] from my PC [10.1.10.222] using MySQL Workbench and when I test the connection, I get the following error: "Host 'tuna.iamghost.com' is not allowed to connect to this MySQL server." Can someone please tell me what I need to do so I can allow r

Re: query executes very slow in a table with 2m records

At 10:36 AM 7/13/2010, Rob Wultsch wrote: On Tue, Jul 13, 2010 at 8:22 AM, mos wrote: > At 09:29 AM 7/13/2010, æ ŽÃ¥Â¾  wrote: >> >> Hello, >> >> There are more than 2m records in the table -- fxrate. >> I create patitions, indexes, but it still takes me about 7 minutes to >> execute the follo

Re: How to become a DBA on MySQL

On 7/13/2010 9:24 AM, alba.albetti wrote: Hi, I'd like to know which are the main tasks for a DBA, so in addition of the on-line tutorial of MySQL, is there anyone telling me whether there exists some tutorial (better if in PDF) where it's possible to undestand and learn all you need for manag

RE: How to become a DBA on MySQL

You might want to see if there are any online classes that could get you started. I usually start by reading a big, thick book -- but I've found that spending a week or two on an introductory-level online class gives me a big head start. "Modern" documentation tends to be lacking (IMNSHO). All

Re: How to become a DBA on MySQL

Reference is everywhere, but you need a sort of starting point. In your case I would say get this book and read: - Part III - Part IV-D (quick read) You will benefit from Part I as

Re: query executes very slow in a table with 2m records

On Tue, Jul 13, 2010 at 8:22 AM, mos wrote: > At 09:29 AM 7/13/2010, æ Žå¾  wrote: >> >> Hello, >> >> There are more than 2m records in the table -- fxrate. >> I create patitions, indexes, but it still takes me about 7 minutes to >> execute the following query >> SELECT COUNT(*) >> FROM fxrate >>

RE: query executes very slow in a table with 2m records

You didn't include an EXPLAIN of your query (please use \G so that it is easy to read), but my guess is that MySQL decided to use a serial search rather than use an index. It is retrieved 1/4 of your records, and that's after applying the MONTH() test. The BETWEEN clause is the only place it can

Re: query executes very slow in a table with 2m records

At 09:29 AM 7/13/2010, 李征 wrote: Hello, There are more than 2m records in the table -- fxrate. I create patitions, indexes, but it still takes me about 7 minutes to execute the following query SELECT COUNT(*) FROM fxrate WHERE MONTH(quoteDate) = 6 AND quoteHourMinSec BETWEEN "06:00:00" AND

query executes very slow in a table with 2m records

Hello, There are more than 2m records in the table -- fxrate. I create patitions, indexes, but it still takes me about 7 minutes to execute the following query SELECT COUNT(*) FROM fxrate WHERE MONTH(quoteDate) = 6 AND quoteHourMinSec BETWEEN "06:00:00" AND "19:00:00" result: 647337 How can I i

Re: How to become a DBA on MySQL

The term DBA is very broad and I think most DBA's do at least some development and if they have *nix platform they probably look after that too. Some, including myself, get heavily involved in the applications running on their db. So long as you can quickly identify and solve database issues, size

ANN: Database Workbench 4.0.3, the multi-DBMS IDE now available!

Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular multi-DBMS development tool: " Database Workbench 4.0.3 Pro " This release includes the FREE Lite versions for InterBase, Firebird and MySQL. Version 4 introduced full Unicode support, 4.0.3 fixes som

Re: How to become a DBA on MySQL

On Tue, Jul 13, 2010 at 8:24 AM, alba.albetti wrote: > Hi, > I'd like to know which are the main tasks for a DBA, so in addition of the > on-line tutorial of MySQL, is there anyone telling me whether there exists > some tutorial (better if in PDF) Sure, the MySQL Reference Manual http://dev.mys

Re: How to become a DBA on MySQL

On Tue, Jul 13, 2010 at 6:24 AM, alba.albetti wrote: > Hi, > I'd like to know which are the main tasks for a DBA, so in addition of the > on-line tutorial of MySQL, is there anyone telling me whether there exists > some tutorial (better if in PDF) where it's possible to undestand and learn > al

How to become a DBA on MySQL

Hi, I'd like to know which are the main tasks for a DBA, so in addition of the on-line tutorial of MySQL, is there anyone telling me whether there exists some tutorial (better if in PDF) where it's possible to undestand and learn all you need for managing the MySQL DB as DBA? I mean I'd like to

Re: How to decode base64 encoded text from mysql

>   > Hi All, >   > Is there any way I can decode base64 encoded message from mysql. I tried > using mysql decode function but it did not work for me. >   > Can anyone provide any input on how I should go about it. >   > Thanks and Regards, > Manasi Save >   base64? -- bEsT rEgArDs

How to decode base64 encoded text from mysql

  Hi All,   Is there any way I can decode base64 encoded message from mysql. I tried using mysql decode function but it did not work for me.   Can anyone provide any input on how I should go about it.   Thanks and Regards, Manasi Save   -- MySQL General Mailing List For list archives: http://list

Re: Triggers and "FOR EACH ROW"

Manao ahoana, Hello, Bonjour, I just read several documentation on MySQL triggers. The way to create triggers is: CREATE TRIGGER t21_au BEFORE UPDATE ON t22 FOR EACH ROW BEGIN // ... END; The trigger I want is only on UPDATE. Is "FOR EACH ROW" referring to "each existing row in the table", or

Re: how to setup replication - MySQL 5.0.x - Migration and new databases

I'm a novice myself and yes I must say on-line documentation is not easy nor comprehensive, let's take this page as an example: http://dev.mysql.com/doc/refman/5.1/en/replication-howto-rawdata.html if I don't use InnoDB Hot Backup, doc says.. "..Otherwise, you can obtain a reliable binary snaps

Triggers and "FOR EACH ROW"

Manao ahoana, Hello, Bonjour, I just read several documentation on MySQL triggers. The way to create triggers is: CREATE TRIGGER t21_au BEFORE UPDATE ON t22 FOR EACH ROW BEGIN // ... END; The trigger I want is only on UPDATE. Is "FOR EACH ROW" referring to "each existing row in the table",

Re: finding exact query being run

Which will still not be particularly helpful for subsecond queries :-) Either turn on the full query log (beware of I/O implications, use separate spindles if possible) or use mk-query-analyzer with tcpdump to get a running analysis of what passes the line. The addition of tcpdump support is my a