Securing MySQL on Mac OSX

I am in the process of installing MySQL and PHP on my Mac following instruction in a book written by a chap called David Powers. I have come to a section that is called 'Securing MySQL on Mac OSX'. Basically it states that MySQL is up and running with a default account of 'root' and it's

Re: Securing MySQL on Mac OSX

It mentions that root in MySQL has nothing to do with the root of Mac OSX, but I need to know if MySQL being unprotected in this way has opened a door for hackers. it means that they can do whatever they want to the mysql db's without being prompted for a password. This does not mean

Re: mysqlimport remote host problem

zcat /Backup/Latest/alba2_2009-03-10_00h45m.Tuesday.sql.gz | mysql -h 192.168.0.224 -u root -p alba2 Cheers Claudio 2009/3/11 Rob Wultsch wult...@gmail.com On Tue, Mar 10, 2009 at 7:16 PM, René Fournier m...@renefournier.com wrote: OK, I've managed to do the same thing with just the

Re: BSD/OS and 5.1

Hi Dave, There is not enough information here to know if your test is failing or your compile is bad. Did the compile complete without errors? What version of BSD/OS are you using there are many versions and varieties. Most of them have a package system with per-built binaries, I would

Re: using a subquery/self-join to recursively retrieve a tree

as you say you need recursion to build the tree from the table. if you are interested just in all the employees that are not manager with their manager info. select * from emp e1 inner join emp e2 on e1.uidman=e2.uid; cheers Claudio 2009/3/10 Ali, Saqib docbook@gmail.com Hello, I

Linking mysqlclient to a windows program

Hello I have configured my VC++ to link my programs with mysqlclient, but now am trying a program with Qt that is compiled using make from the command line, is it enough to add mysqlclient.lib to my makefile library configuration? I mean, is it enough to add the path to the header files and

MySQL Installation Not Working

Hi, I've tried several times now to get a local installation of MySQL going on my iMac (w/ OS X ver. 10.5.6). I've carefully tried everything I could comprehend to do per the mysql.com resource pages/ manual. I have also tried several procedures I discovered via Google searches that

Re: generic remote command/script for monitoring MySQL instance health

On Mon, 9 Mar 2009, Sven wrote: Hi folks I am searching for a generic command to monitor that MySQL instance is up and running. I don't have any know-how about the schema of the DB. kind regards Sven Aluoor Hi What about 'mysqladmin ping' ? Regards, Thomas Spahni -- MySQL General Mailing

Question about LVM snapshots and innodb tables

The book “High Performance MySQL” states the following about using LVM snapshots with innodb tables: “All innodb files (InnoDB tablespace files and InnoDB transaction logs) must be on a single logical volume (partition).” Here is portion of a df command performed on one of our hosts:

Re: mysqlimport remote host problem

Thanks. That works great. On 10-Mar-09, at 9:36 PM, Rob Wultsch wrote: On Tue, Mar 10, 2009 at 7:16 PM, René Fournier m...@renefournier.com wrote: OK, I've managed to do the same thing with just the mysql command line program: mysql -h 192.168.0.224 -u root -p alba2

Re: generic remote command/script for monitoring MySQL instance health

On 3/11/09, Thomas Spahni t...@lawbiz.ch wrote: I am searching for a generic command to monitor that MySQL instance is up and running. I don't have any know-how about the schema of the DB. What about 'mysqladmin ping' ? Hi Thomas thank you. That was the command I searched. kind regards

Re: [PHP] RE: non-auto increment question

Ashley Sheridan wrote: On Thu, 2009-02-26 at 11:27 -0500, PJ wrote: Jerry Schwartz wrote: Being rather new to all this, I understood from the MySql manual that the auto_increment is to b e used immediately after an insertion not intermittently. My application is for administrators (the site

Replica questions

I've got 2 questions about my newly set up master-slave replica. 1 When I run load data from master; I get an error that I do not have RELOAD privileges and then it boots the slave offline. I've run GRANT SELECT, PROCESS, FILE, SUPER, REPLICATION CLIENT, REPLICATION SLAVE, RELOAD ON *.* TO

Query from HPM book to limit rows scanned doesn't appear to work as described

Using 5.0.67-0ubuntu6 on Ubuntu 8.10. I'm going through the High Performance MySQL book. I was reading section 4.4.1.8, titled MIN() and MAX(). The point of this is that MySQL doesn't optimize MIN()/MAX() very well, but it showed a supposed workaround for this. The first sample query was:

Re: Replica questions

On Wed, Mar 11, 2009 at 4:03 PM, Bryan Irvine sparcta...@gmail.com wrote: I've got 2 questions about my newly set up master-slave replica. 1 When I run load data from master; I get an error that I do not have RELOAD privileges and then it boots the slave offline. I've run GRANT SELECT,

Re: Replica questions

hi, #2. try adding the information of master into my.cnf then restart the server. thanks 2009/3/12 Bryan Irvine sparcta...@gmail.com: I've got 2 questions about my newly set up master-slave replica. 1 When I run load data from master; I get an error that I do not have RELOAD privileges

Re: Query from HPM book to limit rows scanned doesn't appear to work as described

Hi! On Wed, Mar 11, 2009 at 8:20 PM, David M. Karr davidmichaelk...@gmail.com wrote: Using 5.0.67-0ubuntu6 on Ubuntu 8.10. I'm going through the High Performance MySQL book.  I was reading section 4.4.1.8, titled MIN() and MAX().  The point of this is that MySQL doesn't optimize MIN()/MAX()

Re: Replica questions

That's deprecated too :-) On Wed, Mar 11, 2009 at 9:17 PM, Cui Shijun rancp...@gmail.com wrote: hi,  #2.  try adding the information of master into my.cnf then restart the server. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: