On 29/02/12 12:38, Brown, Charles wrote:
Hello,
Can someone give me syntax to create a user called starsky and password hutch
with the following objectives:
- user the minimum to run back scripts
- user has the minimum to lock tables
- user has the minimum to do SELECT on tables
Thx
- Original Message -
From: Charles Brown cbr...@bmi.com
Anyone out there with experience in Mysql Clustering. My management
requests that i migrate from replication to clustering. Why? Because
everyone is doing clustering and he would like to stay competitive.
Your management has
*I downloaded **Mac OS X ver. 10.6 (x86, 64-bit), DMG Archive, installed to
my pretty clean os x 10.6.8 (snow leopard) after (1st time) started apache.
The installation went smoothly but the service just cannot be started.*
**
Do you see a MySql icon under System Preferences Other ? That's how
I start MySql on my Mac.
On Wed, Feb 29, 2012 at 9:05 AM, Elim Qiu elim@gmail.com wrote:
*I downloaded **Mac OS X ver. 10.6 (x86, 64-bit), DMG Archive, installed to
my pretty clean os x 10.6.8 (snow leopard) after (1st
The vertion of MySQL that I cannot start is 5.1.61 (the only one for 5.1*
mac at mysql.com)
On Wed, Feb 29, 2012 at 7:05 AM, Elim Qiu elim@gmail.com wrote:
*I downloaded **Mac OS X ver. 10.6 (x86, 64-bit), DMG Archive, installed
to my pretty clean os x 10.6.8 (snow leopard) after (1st
Yes, there is an icon. I can open the preference but the start service
button cannot do the job
On Wed, Feb 29, 2012 at 7:20 AM, Darryle Steplight dstepli...@gmail.com
wrote:
Do you see a MySql icon under System Preferences Other ? That's how
I start MySql on my Mac.
**
I have version 5.5.17 MySQL Community Server (GPL) on my Mac.
On Wed, Feb 29, 2012 at 9:36 AM, Elim Qiu elim@gmail.com wrote:
The vertion of MySQL that I cannot start is 5.1.61 (the only one for 5.1*
mac at mysql.com)
On Wed, Feb 29, 2012 at 7:05 AM, Elim Qiu elim@gmail.com wrote:
On Wed, Feb 29, 2012 at 7:46 AM, Elim Qiu elim@gmail.com wrote:
Yes, there is an icon. I can open the preference but the start service
button cannot do the job
What is in the mysql error log?
On Wed, Feb 29, 2012 at 7:20 AM, Darryle Steplight dstepli...@gmail.com
wrote:
Do you see a
Thanks Larry and Darryle for your help
Where the error log should be?
On Wed, Feb 29, 2012 at 8:22 AM, Larry Martell larry.mart...@gmail.comwrote:
On Wed, Feb 29, 2012 at 7:46 AM, Elim Qiu elim@gmail.com wrote:
Yes, there is an icon. I can open the preference but the start service
On Wed, Feb 29, 2012 at 10:17 AM, Elim Qiu elim@gmail.com wrote:
Thanks Larry and Darryle for your help
Where the error log should be?
http://dev.mysql.com/doc/refman/5.0/en/error-log.html
On Wed, Feb 29, 2012 at 8:22 AM, Larry Martell larry.mart...@gmail.com
wrote:
On Wed, Feb 29,
Little help...
In my mySQL query editor, I am trying to return a value of 0 when
there is no related rows from this query:
(select if(count(ip.payment_amount) IS NOT NULL,
count(ip.payment_amount) , 0) FROM tl_trans_pmt_items ip WHERE
t.transaction_id = ip.inv_id GROUP BY ip.inv_id) as
-rw-r--r-- 1 rootwheel 17987 Dec 17 09:01 COPYING
-rw-r--r-- 1 rootwheel 7371 Dec 17 09:01 INSTALL-BINARY
-rw-r--r-- 1 rootwheel 2552 Dec 17 09:01 README
drwxr-xr-x 46 rootwheel 1564 Dec 17 09:01 bin
drwxr-x--- 8 _mysql wheel272 Feb 29 10:36 data
drwxr-xr-x 4
Are you looking in /usr/local/mysql/data ? You should see a
username.err file. You might have to sudo to open the file just do
sudo tail -f FILENAME or sudo taill -f /path/to/filename/ .
On Wed, Feb 29, 2012 at 1:00 PM, Elim Qiu elim@gmail.com wrote:
-rw-r--r-- 1 root wheel 17987 Dec
It sounds like you've been handed a mandate that's difficult to
understand, but it could be because I don't understand the context, or
you may not understand your manager's real intention. In any case,
everyone is doing clustering is certainly not accurate. And every
clustering technology is
On Wed, Feb 29, 2012 at 11:00 AM, Elim Qiu elim@gmail.com wrote:
-rw-r--r-- 1 root wheel 17987 Dec 17 09:01 COPYING
-rw-r--r-- 1 root wheel 7371 Dec 17 09:01 INSTALL-BINARY
-rw-r--r-- 1 root wheel 2552 Dec 17 09:01 README
drwxr-xr-x 46 root wheel 1564 Dec 17
http://dev.mysql.com/doc/refman/5.0/en/control-flow-functions.html#function_ifnull
On Wed, Feb 29, 2012 at 13:15, Don Wieland d...@pointmade.net wrote:
Little help...
In my mySQL query editor, I am trying to return a value of 0 when there is
no related rows from this query:
(select
You may be interested in this:
http://www.mysqlperformanceblog.com/2009/09/28/how-number-of-columns-affects-performance/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
If you are going to use su to officially switch to the root users
just make sure you do su - with the dash.
On Wed, Feb 29, 2012 at 2:10 PM, Reindl Harald h.rei...@thelounge.net wrote:
Am 29.02.2012 19:20, schrieb Larry Martell:
Is the sudo succeeding? If it is, then there's no reason you
On 2/29/2012 1:15 PM, Don Wieland wrote:
Little help...
In my mySQL query editor, I am trying to return a value of 0 when
there is no related rows from this query:
(select if(count(ip.payment_amount) IS NOT NULL,
count(ip.payment_amount) , 0) FROM tl_trans_pmt_items ip WHERE
t.transaction_id
I created (or activated) the root account and now I see the error log:
sh-3.2# cat miniMac.local.err
120229 10:36:09 mysqld_safe Starting mysqld daemon with databases from
/usr/local/mysql/data
120229 10:36:09 [Warning] Setting lower_case_table_names=2 because file
system for
Sounds like you need to LEFT JOIN:
SELECT *
FROM CUSTOMERS
LEFT JOIN CALLS ON CUSTOMERS.PHONE = CALLS.PHONE AND CALLS.DATE = 02/28/12
WHERE CUSTOMERS.DATE = 02/28/12
But that would only get customers created on 2/28 AND having a call on 2/28
OR not call at all on 2/28.
This would give you
Looks like 5.1.61 mac installer messed up the privilege setting...
But how to fix it? I remember the server account is mysql, not _mysql
What do you got? And how to fix it? Thanks
On Wed, Feb 29, 2012 at 2:20 PM, Elim Qiu elim@gmail.com wrote:
I created (or activated) the root account and
On Wed, Feb 29, 2012 at 2:20 PM, Elim Qiu elim@gmail.com wrote:
I created (or activated) the root account and now I see the error log:
sh-3.2# cat miniMac.local.err
120229 10:36:09 mysqld_safe Starting mysqld daemon with databases from
/usr/local/mysql/data
120229 10:36:09 [Warning]
JW,
I'm trying to understand LEFT JOIN as we go - but it's not working.
This query
SELECT *
FROM CUSTOMERS
LEFT JOIN CALLS ON CUSTOMERS.PHONE = CALLS.PHONE
WHERE CUSTOMERS.DATE = 02/28/12 AND (CALLS.PHONE IS NULL OR CALLS.DATE =
02/28/12)
Is giving me some results which I'm
what about
select customers.* from customers left join calls on
(customers.date=calls.date) where customers.date=02/28/12;
of course date should be an index in both tables.
I think it migth work
On Wed, Feb 29, 2012 at 4:54 PM, LUCi5R luc...@luci5r.com wrote:
JW,
I'm trying to understand
Be kind, I am by no means any type of DB expert.
I would like to eventually move this to a stored procedure but for now I
am using the \. to fire it off.
Here is what I have so far (generating a list of machines missing software)
select last_logon.host_name_short
from last_logon
left join
; 2012/02/29 15:29 -0600, Johnny Withers
Sounds like you need to LEFT JOIN:
SELECT *
FROM CUSTOMERS
LEFT JOIN CALLS ON CUSTOMERS.PHONE = CALLS.PHONE AND CALLS.DATE = 02/28/12
WHERE CUSTOMERS.DATE = 02/28/12
But that would only get customers created on 2/28 AND having a call on 2/28
OR not call
27 matches
Mail list logo
