I'm considering MySQL certification, and I'm wondering which
certifications I should target. I've been developing using MySQL for
about 4-5 years, but am looking to get out of development and into a
DBA role. I've worked with various database engines for about 20
years, so it would seem
I've just made it through the MySQL Certification Study Guide and have
found it to have pretty good coverage of tuning as well as other
subjects. There are probably more in-depth sources available, but it
might be a good place to start.
- Dan-o
On Aug 9, 2004, at 12:42 AM, Eko Budiharto
I am by no means a phpMyAdmin guru, but the version I have (2.5.7) has
an option for it, accessible by clicking on the Databases link from
the main page. I suspect, however, that they will give you a single
database that you will not have the DROP DATABASE privilege for and
that you will
I'm unable to get the 4.1.3 server to start automatically at startup or
even manually unless I'm logged in as root. I'm on an iBook G4. I
downloaded and installed the
mysql-standard-4.1.3-beta-apple-darwin7.4.0-powerpc binary and the
associated startup item. I've done this successfully with
Another use for binary columns is for case-sensitive text such as
passwords. If you store text in a CHAR, VARCHAR, or TEXT column,
comparisons will not be case-sensitive unless you use the BINARY
keyword. An example (from section 6.3.22 of the Language Reference:
mysql SELECT a = A;
You need to use the 'GROUP BY' clause:
SELECT offerid, resellerid, MIN(price) FROM A GROUP BY resellerid;
Cheers,
Dan
On Jul 30, 2004, at 2:37 PM, Haitao Jiang wrote:
Hi, there
Maybe this question is not MySQL specific, but I just wondering if
MySQL has any way to doing this:
I have a table A like
Just thought I'd share my experience with MySQL under Panther. I think
the critical thing that got me going was that the /usr/local/mysql/data
directory was owned by root instead of mysql. I changed that (chown
mysql /usr/local/mysql/data) and everything seems to be a) Hunky b)
Dory, thanks
Which distribution should I install on Mac OS X Panther? Thanks.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I have been trying for months to set up mysql on my Mac (Panther) with
no success. I can't run mysqladmin as root. I get an access denied
error message. If I try to use SHELLmysqladmin -u root password
'password' I get access denied as either root or the regular user. I
can't run mysql as
Ok, I've read the release notes, the manual, the threads on this
mailing list, installed/removed/re-installed about 5 times, tried
4.0.1, 4.1, 5.0, and I can't get MySQL to run on my Mac (dual-proc
867MHz, 768MB RAM). When I run configure, it tells me everything is
hunky-dory and that I
10 matches
Mail list logo