I had MySQL 5.5.15 running on OS X Lion, deleted it, and tried to install
5.5.17. I have run into problems that I cannot solve.
To begin with the end, I can run start mysqld with the skip-grant-tables
option and connect with mysql. If I issue the command
select * from mysql
the result returns
I have been struggling with installing MySQL 5.5.17 on a Mac running OS
10.7. My machine had 5.5.15 on it.
I keep getting user denied access messages (Error 1045). I thought at
first it was a matter of a password not being flushed from a previous
installation and went through repeated install
Is it possible to make utf8 the default for all databases and transactions
in a MySQL installation?
The current default is Latin1. There is a suggestion on the Web to edit
the my.cnf file as follows
[mysqld]
init_connect=’SET collation_connection = utf8_general_ci’
init_connect=’SET NAMES utf8′
There is good advice by Rob Allen at
http://akrabat.com/computing/uninstalling-mysql-on-mac-os-x-leopard/
for the Mac
To uninstall MySQL and completely remove it (including all databases) from
your Mac do the following:
* Use mysqldump to backup your databases to text files!
* Stop the database
or some notebook where
you never find it again?
Martin Mueller
Professor emeritus of English and Classics
Northwestern University
Is there a unicode setting on mysql that is case insensitive but
diacritics sensitive? Given 'Ete', 'été', 'ete' a group by routine for
such a setting would return two values: 'été', 'ete'. I couldn't find
it, but I may not have known where to look.
Martin Mueller
Professor emeritus
Thanks for that answer. It squares with my solution: have an additional
column that has the lower case values of the case sensitive unicode
setting.
Martin Mueller
Professor emeritus of English and Classics
Northwestern University
On 11/25/14 6:48 AM, Rik r...@grib.nl wrote:
Not a unicode
COMMENT = 'b'
END IF
But this gives me an error message. What am I doing wrong?
MM
Martin Mueller
Professor emeritus of English and Classics
Northwestern University
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
:-)
- Original Message -
From: Johan De Meersman vegiv...@tuxera.be
To: Pothanaboyina Trimurthy skd.trimur...@gmail.com
Cc: Martin Mueller martinmuel...@northwestern.edu, MySql
mysql@lists.mysql.com
Sent: Monday, 4 May, 2015 16:11:24
Subject: Re: create_time
That sounds logical. I have
I had thought that MySQL remembers the date when a table is first created
and stores it in the create_time column of Information Schema. But this
doesn¹t seem to be the case.On my machine it seems to record the date of
most recent access. Which seems odd.
Am I doing something wrong? Is there a
months all of a
sudden showed a create_time that was more or less identical with the last
update of the table. Which surprised me.
From: Pothanaboyina Trimurthy
skd.trimur...@gmail.commailto:skd.trimur...@gmail.com
Date: Friday, May 1, 2015 at 12:15 AM
To: Martin Mueller
martinmuel
I understand how a timestamp column automatically changes when there is a
change in a data row. Is it possible to limit the update to changes in
particular columns? I have a table where I care about changes in any of
four different columns, but I don¹t care about changes in other columns or
added
are identified as not existing, although it is there on the hard
drive with substantial byte counts.
Is there something I can do about this or is it an intrinsic problem to
moving INNO tables?
Martin Mueller
Professor emeritus of English and Classics
Northwestern University
--
MySQL General
without updating file.
I'll be grateful for any help
Martin Mueller
Professor emeritus of English and Classics
Northwestern University
path
mention, but neither does the my.cnf file on a laptop, which works. So there
seems to be nothing wrong with the location or content of the my.cnf file.
On Fri, Jul 31, 2015 at 5:11 AM, Martin Mueller
martinmuel...@northwestern.edumailto:martinmuel...@northwestern.edu wrote:
I have installed
not a very experienced programmer and have trouble wrestling with the
command line. But I think I did my due diligence and didn't find any open
doors.
Martin Mueller
Professor emeritus of English and Classics
Northwestern University
On 7/31/15 3:36 AM, Reindl Harald h.rei...@thelounge.net wrote
help you a lot
to practice a little courtesy and refrain from vulgar language.
Martin Mueller
Professor emeritus of English and Classics
Northwestern University
On 7/31/15 9:12 AM, Reindl Harald h.rei...@thelounge.net wrote:
Am 31.07.2015 um 15:40 schrieb shawn l.green:
1. Log on to your
and MySQL is a very popular database. So I don't quite understand
why very basic installation and operating procedures are so complicated.
Martin Mueller
Professor emeritus of English and Classics
Northwestern University
On 7/31/15 8:40 AM, shawn l.green shawn.l.gr...@oracle.com wrote:
On 7/31
uninstalled and re-installed the
program, but the results are always the same.
Martin Mueller
Professor emeritus of English and Classics
Northwestern University
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
MySQL has a bewildering variety of unicode collation choices. Most of them are
language specific, but what is the difference between "utf8-general-ci",
"utf8-unicode-ci", and "utf8-unicode-520-ci." Do they differ in the range of
characters they can handle or is it just a matter of the cort
keep the
old along the new, just in case something goes wrong/
My friends tell me to use sqlite, and they are probably right since file
management is so much simpler. But I find the many builtin functions of MySQL
very helpful and don't particularly want to learn a new set.
Martin Mueller
and unknown dependencies in that approach?
Martin Mueller
Professor emeritus of English and Classics
Northwestern University
I run MySQL 5.6 on OS 10.11. There is a table that appears to be corrupt: it
does not respond to queries, and the command to drop it does not execute. The
database seems to be OK in other respects. What can I do to get rid of the
table? Would it be safe just to remove the two .frm and .ibd
on writing called the “curse of ignorance,”
the fact that one neither knows nor cares about what the other person doesn’t
know.
On 7/2/16, 9:11 PM, "Hal.sz S.ndor" <h...@tbbs.net> wrote:
2016/07/02 18:49 ... Martin Mueller:
> It’s clear from Section 6.6 of the Reference
organized
functions, and it’s a joy to work with once you have it actually installed an
running.
I’ll be grateful for any help.
Martin Mueller
Professor emeritus of English and Classics
Northwestern University
On 4/21/16, 5:42 PM, "shawn l.green" <shawn.l.gr...@oracle.com> w
. And
biting your tongue might be a good thing for others
MM
Martin Mueller
Professor emeritus of English and Classics
Northwestern University
On 9/11/16 12:27 PM, "Ryan Coleman" <ryan.cole...@cwis.biz> wrote:
>Because they want to be belittled by european jackasses online.
>
>
I abandoned a MySQL 5.22 database that quite suddenly andthat I wasn’t able to
start up again. The data directory consists of a mix of ISAM and Inno tables.
I was able to copy the ISAM tables into a new 5.6 version, and they work.
I understand that INNO tables are different because different
I have been trying repeatedly and in vain to install the community edition of
MySQL 5.7.16 on an iMac running OS sierra. I religiously followed the
instructions for uninstalling previous versions found at
http://community.jaspersoft.com/wiki/uninstall-mysql-mac-os-x, and installation
nk.net> wrote:
On 12/2/2016 16:59, Martin Mueller wrote:
> I have been trying repeatedly and in vain to install the community
edition of MySQL 5.7.16 on an iMac running OS sierra. I religiously followed
the instructions for uninstalling previous versions found at
https://urldefens
/mysql/support-files/mysql.server start
starts it
On 12/3/16, 4:40 PM, "Peter Brawley" <peter.braw...@earthlink.net> wrote:
On 12/3/2016 13:58, Martin Mueller wrote:
> I was able to install a version of MySQL 5.6 on OS Sierra. It appears
that the “launchdaemon’
30 matches
Mail list logo