Re: a curse on OS sierra and MySQL?
Well, the command sudo /usr/local/mysql/support-files/mysql.server stop generates the error message: ERROR! MySQL server PID file could not be found! On the other hand, sudo launchctl unload -F /Library/LaunchDaemons/com.oracle.oss.mysql.mysqld.plist stops the server and sudo /usr/local/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’ method works while the mysql.server start/stop method does not work. In retrospect I should have seen that, but I also think that the official documentation could and should be more explicit about what is a significant change in Apple’s start/stop routines. If you mean that seriously, it needs to be more specific. PB - > > On 12/3/16, 12:43 PM, "Peter Brawley" <peter.braw...@earthlink.net> wrote: > > On 12/2/2016 17:58, Martin Mueller wrote: > > Alas, running the stop and start commands under sudo makes zero difference. > > ?! The cited page recommends more than sudo starts and stops, eg ... > > |unset TMPDIR mysql_install_db | > > Did you try that? Did you check the pid setting in my.cnf, eg > pid-file=/var/run/mysqld/mysqld.pid? I believe you need to ensure that > the pid file specified in my.cnf exists and that the mysql daemon owns > it ... > > mkdir /var/run/mysqld > touch /var/run/mysqld/mysqld.pid > chown -R mysql:mysql /var/run/mysqld > > Also see > https://urldefense.proofpoint.com/v2/url?u=http-3A__superuser.com_questions_159486_how-2Dto-2Dkill-2Dprocess-2Din-2Dmac-2Dos-2Dx-2Dand-2Dnot-2Dhave-2Dit-2Drestart-2Don-2Dits-2Down=CwIDaQ=yHlS04HhBraes5BQ9ueu5zKhE7rtNXt_d012z2PA6ws=rG8zxOdssqSzDRz4x1GLlmLOW60xyVXydxwnJZpkxbk=Rp61bfD4ngoSU50qebNy37Nmv34OSqdiU4Sigj8b9zI=RDN0din-b9O7hEkNJOKe1CbYe_5MipeeuN2oeOMsWfI= > > > This is a very frustrating problem, and I hope somebody in the MySQl documentation department will take a look at it. It’s cleary a problem that has been around for years because the Web is full of complaints and tips. But there doesn’t seem to be any convergence a bout a diagnosis or a likely cure. And there is nothing in the MySQL documentation that draws attention to the probem. > > > > In my case, I’m double frustrated because some months ago my MySQL application broke around this problem, and then a couple of weeks ago it cured itself when I somewhat arbitrarily picked up an earlier version of my installation from Time Machine. > That suggests the problem arose from a change in your app, or a setting > change that occurred in a MySQL upgrade. To show that this is a common > problem that MySQL docs ought to address, you'll need to identify the > setting that's gone awry. > > PB > > > -- MySQL General Mailing List For list archives: https://urldefense.proofpoint.com/v2/url?u=http-3A__lists.mysql.com_mysql=CwIDaQ=yHlS04HhBraes5BQ9ueu5zKhE7rtNXt_d012z2PA6ws=rG8zxOdssqSzDRz4x1GLlmLOW60xyVXydxwnJZpkxbk=I5PKsknY5e1wjZZG11zhg1tGbZKrqgs0FExanPNtMkk=40lzUebvOmuxTUq-dnXHbwXgaFEyIyYqf93pjPGQibU= To unsubscribe: https://urldefense.proofpoint.com/v2/url?u=http-3A__lists.mysql.com_mysql=CwIDaQ=yHlS04HhBraes5BQ9ueu5zKhE7rtNXt_d012z2PA6ws=rG8zxOdssqSzDRz4x1GLlmLOW60xyVXydxwnJZpkxbk=I5PKsknY5e1wjZZG11zhg1tGbZKrqgs0FExanPNtMkk=40lzUebvOmuxTUq-dnXHbwXgaFEyIyYqf93pjPGQibU= -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
rescue Inno tables from an abandoned data directory?
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 tables share a common table space. The MySQL documentation refers to a “cold backup,” where you copy the separate files after a “slow shutdown.” It doesn’t tell you what to do with them after you’ve put them in a “safe place.” In my case, I can reproduce Time machine backups of data directories at varying times. At one point I was able to replace the non-working installation with an earlier installation, but then it failed unpredictably. Are the Inno tables on Time Machine useless, or can I rescue data from them? I’ll be grateful for help
Re: a curse on OS sierra and MySQL?
Alas, running the stop and start commands under sudo makes zero difference. This is a very frustrating problem, and I hope somebody in the MySQl documentation department will take a look at it. It’s cleary a problem that has been around for years because the Web is full of complaints and tips. But there doesn’t seem to be any convergence a bout a diagnosis or a likely cure. And there is nothing in the MySQL documentation that draws attention to the probem. In my case, I’m double frustrated because some months ago my MySQL application broke around this problem, and then a couple of weeks ago it cured itself when I somewhat arbitrarily picked up an earlier version of my installation from Time Machine. But after a couple of weeks it suddenly failed in the same way although I had done nothing on the system administration end. I’m not a programmer, but I’ve worked with lots of programs, and MySQL, which is wonderful when it works, is absolutely the worst in the obscure and poorly documented steps that take you from the code to an installation that works. At least that is the case with OS 10. On 12/2/16, 5:42 PM, "Peter Brawley" <peter.braw...@earthlink.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://urldefense.proofpoint.com/v2/url?u=http-3A__community.jaspersoft.com_wiki_uninstall-2Dmysql-2Dmac-2Dos-2Dx=CwIDaQ=yHlS04HhBraes5BQ9ueu5zKhE7rtNXt_d012z2PA6ws=rG8zxOdssqSzDRz4x1GLlmLOW60xyVXydxwnJZpkxbk=LP2YLfUL67Gr-H-dkv9ZuW5LDsLMTL-M7m7g50wBPu4=sqlfF8DCjesZOKwqOhB8bmyF0bkpvNWHU8cXz-amxg4= , and installation progresses smoothly and terminates successfully. Bu the attempt to start the server produces the error message : > ERROR! MySQL server PID file could not be found! Is https://urldefense.proofpoint.com/v2/url?u=http-3A__stackoverflow.com_questions_861_pid-2Derror-2Don-2Dmysql-2Dserver-2Dstart=CwIDaQ=yHlS04HhBraes5BQ9ueu5zKhE7rtNXt_d012z2PA6ws=rG8zxOdssqSzDRz4x1GLlmLOW60xyVXydxwnJZpkxbk=LP2YLfUL67Gr-H-dkv9ZuW5LDsLMTL-M7m7g50wBPu4=M2Yd8vqNwYiRfeLsjhV2Ut_dG-pxlDiy5d-eEx1rubQ= helpful? PB -
a curse on OS sierra and MySQL?
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 progresses smoothly and terminates successfully. Bu the attempt to start the server produces the error message : ERROR! MySQL server PID file could not be found! I have tried this and that, looking at advice on the Web, which is plentiful but not always. Nothing works. I have installed Postgresql, about which I know very little. But the installation proceeded smoothly, and turning the server on and off works like a charm. Is it a reasonable conclusion that MySQl and OS 10 just don’t like each other very much and that a prudent man is better off with some other database? The MySQL documentation is not very helpful in the sense that following it doesn’t produce good results.
Re: MySQL Platform Migration
Not very helpful rhetoric on either side of the fence. Every time an unnecessary comment is made, some time cost is imposed on the folks who make the mistake of opening the email thinking there was some useful advice. Civilization and good manners consist very largely of bitten tongues. 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. > >On Sep 10, 2016, at 11:56 PM, Reindl Harald <h.rei...@thelounge.net> >wrote: >> >> >> Am 11.09.2016 um 06:36 schrieb Suresh Rajagopal: >>> Is the mysql datafile compatible with different operation system ? I >>>have not done this in the past. >> >> why shouldn't it when the identical software is running? >> it's just a bunch of files used by mysql >> >> as said copy it to the new machine and you are done - why do people >>these days not just try out things, look if it works and when it don't >>asking questions? >> >>> - Original Message - >>> From: Reindl Harald <h.rei...@thelounge.net> >>> To: mysql@lists.mysql.com >>> Sent: Saturday, September 10, 2016 7:19 PM >>> Subject: Re: MySQL Platform Migration >>> >>> Am 11.09.2016 um 00:26 schrieb Suresh Rajagopal: >>>> Is there any documentation for migrating mysql 5.0 database from >>>>darwin to Linux >>> >>> what do you need to migrate? >>> >>> shutdown mysqld, copy the datadir to the new machine, start mysqld with >>> adopted configuration on the new machine - done >>> >>> P.S: >>> don't cross-post on mysql and mariadb list >> >> -- >> MySQL General Mailing List >> For list archives: >>https://urldefense.proofpoint.com/v2/url?u=http-3A__lists.mysql.com_mysql >>=CwIFAg=yHlS04HhBraes5BQ9ueu5zKhE7rtNXt_d012z2PA6ws=rG8zxOdssqSzDRz >>4x1GLlmLOW60xyVXydxwnJZpkxbk=cQyy1LyUdO1_o4_3K62-IxYpnXPNhcErgHZ2NXXmnT >>c=tiL5vs-xwiEX93V1KAJ7sw4QOg-ZD1qBrflS_f0lMow= >> To unsubscribe: >>https://urldefense.proofpoint.com/v2/url?u=http-3A__lists.mysql.com_mysql >>=CwIFAg=yHlS04HhBraes5BQ9ueu5zKhE7rtNXt_d012z2PA6ws=rG8zxOdssqSzDRz >>4x1GLlmLOW60xyVXydxwnJZpkxbk=cQyy1LyUdO1_o4_3K62-IxYpnXPNhcErgHZ2NXXmnT >>c=tiL5vs-xwiEX93V1KAJ7sw4QOg-ZD1qBrflS_f0lMow= >> > > >-- >MySQL General Mailing List >For list archives: >https://urldefense.proofpoint.com/v2/url?u=http-3A__lists.mysql.com_mysql; >d=CwIFAg=yHlS04HhBraes5BQ9ueu5zKhE7rtNXt_d012z2PA6ws=rG8zxOdssqSzDRz4x >1GLlmLOW60xyVXydxwnJZpkxbk=cQyy1LyUdO1_o4_3K62-IxYpnXPNhcErgHZ2NXXmnTc >=tiL5vs-xwiEX93V1KAJ7sw4QOg-ZD1qBrflS_f0lMow= >To unsubscribe: >https://urldefense.proofpoint.com/v2/url?u=http-3A__lists.mysql.com_mysql; >d=CwIFAg=yHlS04HhBraes5BQ9ueu5zKhE7rtNXt_d012z2PA6ws=rG8zxOdssqSzDRz4x >1GLlmLOW60xyVXydxwnJZpkxbk=cQyy1LyUdO1_o4_3K62-IxYpnXPNhcErgHZ2NXXmnTc >=tiL5vs-xwiEX93V1KAJ7sw4QOg-ZD1qBrflS_f0lMow= > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
... ERROR! The server quit without updating PID file
I ran into the problem referred to in the subject line. It seems to be fairly common, to judge from stuff on the Internet, but none of the explanations or solutions offered there were of any help to me. I run MySql 5.22 on a Mac desktop with El Capitan, but the MySQL installation is inherited from an earlier version of OS X. I stopped the server from the MySQL icon in the System Preferences panel, because I wanted to perform a proper binary backup and Dubois’ book said to stop the server especially if you are using INNO tables. When I restarted it with the restart seemed to work for a while but then aborted with the message “... ERROR! The server quit without updating PID file” As I understand it, the start and stop operations for MySQL server on the Mac changed between Yosemite and El Capitan. So it seems plausible to me that the server shut down according to one protocol and the way in which it shut down prevents it now from starting. I turned the computer on and off many times and the MySQL always automatically restarted, but I don’t remember ever stopping it from the MySQL icon in the Mac’s System preferences, and I suspect that using it was the cause of the malfunction. What can I do? One voice on the Internet suggested simply replacing the installation altogether, keeping the data directory and then updating the new data directory with the old one. If I read Paul Dubois’ MySQL manual correctly that should be OK. Because I made what he calls a “binary backup” and all my files are MyISAM or InnoDb and should be machine or version independent. I hesitate because on a previous occasion an older version of MySQL was extraordinarily difficult to get rid of and the machine in later installations seemed to remember a password that I had forgotten. In this case, I know the passwords. So, is the best thing to do 1) Move the data directory out of the current instllation 2) Get rid of the current installation 3) Replace the data directory of the new instllation with the old data directory Or are there problems and unknown dependencies in that approach? Martin Mueller Professor emeritus of English and Classics Northwestern University
Re: parallel installations of mysql
Thanks. That’s helpful and makes me think that there may be a “Mac hole” in the MySQL documentation. Windows is one thing and Linux another. OS X is sort of Unix, but only sort of, and the conventions are not as firmly established. For instance, the instructions for the MySQl Sandbox—on the face of it a useful utility—are much more Linux specific than the author tells you. Making them work on a Mac might be easy for someone who knows a lot about Linux. But if you don’t, as I don’t, you’re stuck It would actually be terrific if MySql 5.7 by default installed itself as a neighbor without encroaching on the 5.6 that is already there, like oXygen. It would be equally terrific if it just superseded 5.6, but let you get on with your work. But it doesn’t do one or the other. It will overwrite without replacing, and you have to take a lot of very careful steps to make sure that things don’t get in each other’s way. The documentation for that, especially on the Mac side, is not good. If port 3306 is taken, how is one supposed to know that 3307 is a good alternative? Why not 3317 or 3703. The MySQL documentation here is plagued by what Steven Pinker in a recent book 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 manual that I need to make sure > that the new installation differs from the old one with regard to the data > directory, the port number, the socket, the shared memory-base-name, and the > pid-file. > > It’s less clear to me where to change these setting. In the .dmg version of a > Mac version, you can’t make any choices. I don’t know whether it’s a bug or a > feature, but the button for customizing an installation doesn’t work. > > So the other option is the .tar file. There are a lot of files in that > directory, but no file that draws attention to itself as the file where you > make these changes. > > Some of the instructions are obscure to folks like me. What is a good port > number? Will anything do, or is there a list somewhere? What do I call an > alternate pid file? Since I use Windows and not Mac, not all my experience is relevant, but there is a file, that for wIndows is called "my.ini" but the original name is "my.cnf", which is full of stuff. For a while I ran both 5.5 and 5.6, with port 3306 for the former and 3307 for the latter. There is on this machine a top-level directory "ProgramData", and the version-5.6 files are under "\ProgramData\MySQL\MySQL Server 5.6" (yuck, backslash). I imagine for version 5.7 there is to be "\ProgramData\MySQL\MySQL Server 5.7". This directory is named in "my.ini". The PID file is under this directory. Maybe some of this maps onto the Mac version. (Iself have begun to use SQLite for some purposes.) -- MySQL General Mailing List For list archives: https://urldefense.proofpoint.com/v2/url?u=http-3A__lists.mysql.com_mysql=CwID-g=yHlS04HhBraes5BQ9ueu5zKhE7rtNXt_d012z2PA6ws=rG8zxOdssqSzDRz4x1GLlmLOW60xyVXydxwnJZpkxbk=BLzHSJhRl4rLPDJAWZ1n77yXtR7Lqg1Y8QC5CQp7BJo=vGlmKmD1QtPMLr9EqCWQyn1arUfs2LuZXkmqj_U5aCU= To unsubscribe: https://urldefense.proofpoint.com/v2/url?u=http-3A__lists.mysql.com_mysql=CwID-g=yHlS04HhBraes5BQ9ueu5zKhE7rtNXt_d012z2PA6ws=rG8zxOdssqSzDRz4x1GLlmLOW60xyVXydxwnJZpkxbk=BLzHSJhRl4rLPDJAWZ1n77yXtR7Lqg1Y8QC5CQp7BJo=vGlmKmD1QtPMLr9EqCWQyn1arUfs2LuZXkmqj_U5aCU=
Re: parallel installations of mysql
Dear Mr. Green, After struggling for several hours with installing an alternate installation of MySQL, I’ve concluded that this may be beyond my feeble powers but also that the official instructions are not very good. They are written for system administrators who are doing work of this kind all the time. I’m a scholar who has a reasonably firm command of SQL code but doesn’t work much at the command line. So you could say “tough luck” or you could try to be a little more explicit in the official instructions. I work with a Mac, and as far as I can tell there isn’t much love lost between Apple and Oracle. And proper Linux users may think of Mac users as wimps. Which they may be. But they still want to use relational databases. It’s clear from Section 6.6 of the Reference manual that I need to make sure that the new installation differs from the old one with regard to the data directory, the port number, the socket, the shared memory-base-name, and the pid-file. It’s less clear to me where to change these setting. In the .dmg version of a Mac version, you can’t make any choices. I don’t know whether it’s a bug or a feature, but the button for customizing an installation doesn’t work. So the other option is the .tar file. There are a lot of files in that directory, but no file that draws attention to itself as the file where you make these changes. Some of the instructions are obscure to folks like me. What is a good port number? Will anything do, or is there a list somewhere? What do I call an alternate pid file? In documentation that would be friendlier, there might be a side-by side scenario, showing the values for the first installation, and possible alternate values for a second installation. And it would help to remind the user, who is not a systems administrator dealing with this stuff every day, where you find the relevant configuration files. It’s an odd feature of MySQL that it doesn’t seem to have an initial configuration file in the tar version of the program. So the question where to go in the first place is not obvious. Having failed to get it right, I tried a MySQL sandbox program that promised to do all this without trouble. Alas, it didn’t work on the Mac at all. Perhaps I should use SQLite, where you don’t have to worry about any of this stuff. On the other hand , MySQL has very elegant and logically 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> wrote: On 4/20/2016 2:04 PM, Martin Mueller wrote: > > I am running MySQL 5.6.22 on an iMac as a desktop database. I would like to > install 5.7.12. Can I install it as a parallel and independent instance? And > if so, are there special problems to watch out for? > > > > > > Why would I want to do this? Well, I have a set of databases and tables on > the old installations that have grown over the years. Given the way I work, > the simplest thing would be install the new database and then work through my > existing tables over a number of weeks and transfer stuff as I go along. > That may not be very professional but it works for me, and it would let me > 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 > Many systems have more than one mysqld running on them at the same time. To make them operate safely, you have to isolate them from each other using the guidance in this section of the manual: http://dev.mysql.com/doc/refman/5.7/en/multiple-servers.html -- Shawn Green MySQL Senior Principal Technical Support Engineer Oracle USA, Inc. - Integrated Cloud Applications & Platform Services Office: Blountville, TN Become certified in MySQL! Visit https://www.mysql.com/certification/ for details. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
corrupt INNO table
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 files from the database directory or is there other stuff that I need to worry about. Thanks in advance for any help.
utf8 options under 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 order. I understand that utf8-bin is different because it is case sensitive, but the other differences elude me. Under what circumstances does it make a difference to use on or the other? I work with a lot of Early Modern print data and the weird symbols of various kinds they use. I've had trouble at times with the "utf8-general-ci" setting, but it may have been more a matter of settings on my front end tool than of the choice of this rather than unicode collation. Under character sets, there is just one utf8 setting. The simplest way to make sense of the choices would be to say that given a character set (utf8) the collation only makes a difference to the sort but makes no difference to what can be displayed. Is that correct.
parallel installations of mysql
I am running MySQL 5.6.22 on an iMac as a desktop database. I would like to install 5.7.12. Can I install it as a parallel and independent instance? And if so, are there special problems to watch out for? Why would I want to do this? Well, I have a set of databases and tables on the old installations that have grown over the years. Given the way I work, the simplest thing would be install the new database and then work through my existing tables over a number of weeks and transfer stuff as I go along. That may not be very professional but it works for me, and it would let me 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
moving inno tables
I moved the data directory of a MySQL installation from one computer to another. This works for MyISAM tables. Unfortunately I inadvertently created some INNO tables, and it doesn't seem to work. The show tables command accurately lists the following the tables from a longer list pospairs | | purchas4 | The ls -l command for the directory /usr/local/mysql/data/tcpcurrent shows what I take to be all the required files for these two tables: -rw-r- 1 _mysql wheel 66152 Jul 28 15:53 pospairs.MYD -rw-r- 1 _mysql wheel 45056 Jul 28 15:53 pospairs.MYI -rw-r- 1 _mysql wheel8664 Jul 28 15:53 pospairs.frm -rw-r- 1 _mysql wheel 13792 Jul 28 15:53 purchas4.frm -rw-r- 1 _mysql wheel 385875968 Jul 28 15:54 purchas4.ibd The permissions are identical, and the file sizes seem appropriate. But the first ISAM file responds while for the INNO file the command mysql select spelling from purchas4 where spelling like 'z%'; produces the response: ERROR 1146 (42S02): Table 'tcpcurrent.purchas4' doesn't exist I ran a mysql check routine on this, and it appears that all of the INNO tables 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 Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: password problem
Data directory path mention in cnf is of old mysql. Make a fresh data directory, configure it in configuration file and execute mysqlinstall_db, I don't understand the sentence about the data directory path mention. The my.cnf file is at /etc/my.cnf . It doesn't have any data directory 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 mysql 5.1.73 on an old Mac Pro running OS Lion. I cannot run the mysql command because it challenges me for a password. But I did not set any password, either for the root, for mysql, or for myself as a user. So the installation has somehow installed passwords about which I know nothing or there is some error in the installation process. There is a lot on the Web about resetting a forgotten password. But the assumption is always that you can get at the program via some other password. But in this case every door is shut. Does anybody recognize this problem? I've 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 -- Thanks and Regards: Nikhil Anand +91 9650024197
Re: password problem
Sorry for the off-list reply. It was an oversight. That said, the instructions for resetting a forgotten root password have a section for Windows and a section for Unix. The Unix section begins as follows: 1. Log on to your system as the Unix user that the MySQL server runs as (for example, mysql). But if I do this with the command 'mysql -u mysql I get the answer Access denied for user 'mysql'@'localhost' (using password: NO) I can do this as super user or normal, and I can try passwords from earlier installations, but none of them work. So I am stopped dead in my tracks, am I not? As for the datadir, the command update db locate mysql works on the Mac and gives me info about a whole set of files in /usr/local/mysql-5.1.73-osx10.6-x86_64. That's where I thought it was, and I deleted a previous installation because I had moved the data I needed to another machine. I'm 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: first: don't reply off-list, a answer on a mailing-list is no invitation for private support! Am 31.07.2015 um 02:34 schrieb Martin Mueller: I read that section but was stopped in my tracks by Log on to your system as the Unix user that the MySQL server runs as (for example, mysql) Because I have no password for ANY thing. read the f**ng https://dev.mysql.com/doc/refman5.0/en/resetting-permissions.html https://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html - unbelievebale that users these days need anything ready chewed and are too lazy to click on a link and read more than 5 lines Resetting the Root Password: Generic Instructions Stop the MySQL server if necessary, then restart it with the --skip-grant-tables option I used the uninstall routine recommended by Rob Allen, in which you remove the directories /usr/local/mysql as well as /usr/local/mysql* and a lot of other library and etc files. So there is no trace of the old system on my machine. How come a routine installation of mysql then locks up the application. the datadir is *not* removed by any sane installer, dunno where it lives on Apple machines since i banned them 5 years ago for good reasons on a non-OSX i would just type updatedb; locate mysql als root On 7/30/15, 19:22, Reindl Harald h.rei...@thelounge.net wrote: Am 31.07.2015 um 01:41 schrieb Martin Mueller: I have installed mysql 5.1.73 on an old Mac Pro running OS Lion. I cannot run the mysql command because it challenges me for a password. But I did not set any password, either for the root, for mysql, or for myself as a user. So the installation has somehow installed passwords about which I know nothing or there is some error in the installation process. There is a lot on the Web about resetting a forgotten password. But the assumption is always that you can get at the program via some other password. But in this case every door is shut. Does anybody recognize this problem? I've uninstalled and re-installed the program, but the results are always the same * install and uninstall *never* removes the datadir * users and permissions are in the DB mysql * https://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: password problem
Dear Mr Harald, I've learned some things from your responses and even more from shawn green's. You might learn a lot from him about patience and courtesy, which make life on a technical forum a lot easier. You clearly know a lot about technical stuff, but you're short on patience, and it would 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 system as the Unix user that the MySQL server runs as (for example, mysql). Everything that executes on a Linux/Unix/Mac machine executes in the context of some kind of user account (the system login). By default, mysqld (the database server daemon) is installed to run under the host machine user account 'mysql'. It can be changed if you want to change it but that is the default. That is why 'mysql' was listed in the for example section of that instruction but this part of the docs is completly bullshit a) on no sane system the user mysql has a password, hence no login possible and typically it has also no shell configured b) for what reason mysql -u root and you are done with skip-grant-tables (and skip-grant-tables is the only relevant point) why in the world should i need to logon as the user mysqld runs for connect to mysqld? but anyways, mysql -u mysql would have worked also as well as mysql -u bullshit because skip-grant-tables does what it says, you can do anything you like to do -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
pid-file quite
Dear Mr. Green, first I'd like to thank you for your very clear explanations, which helped. 'mysql' is an overdetermined word with all the advantages and disadvantages of that. While finally getting into the door, I ran into another problem: pid-file quit without updating. This seems to be a fairly common phenomenon, to judge from offered help on the Web. But the explanations are all over the map, and the help is of dubious value. I've run into this problem several times. One piece of advice was to use ps ax|grep mysql and then kill the processes with the number returned by the query. That worked on one occasion, but on another occasion it didn't. On that occasion, though, if I logged in as superuser and started the server it worked. There doesn't seem to be anything about this problem in the mysql documentation. I not that it seems to be a fairly common kind of error, with no clearly diagnosis or therapy from a source that can speak with much authority. It may be Mac specific and has to do with Startup items that you're not supposed to use anymore and launcher daemons that are not easily understood by poor mortals by me. But OS X is a very popular operating system 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/2015 8:40 AM, Martin Mueller wrote: Sorry for the off-list reply. It was an oversight. That said, the instructions for resetting a forgotten root password have a section for Windows and a section for Unix. The Unix section begins as follows: 1. Log on to your system as the Unix user that the MySQL server runs as (for example, mysql). Everything that executes on a Linux/Unix/Mac machine executes in the context of some kind of user account (the system login). By default, mysqld (the database server daemon) is installed to run under the host machine user account 'mysql'. It can be changed if you want to change it but that is the default. That is why 'mysql' was listed in the for example section of that instruction. But if I do this with the command 'mysql -u mysql I get the answer No. That is how you log into mysqld to open a MySQL client session. The instruction was to login to your operating system as the user that mysqld operates as. These are fundamentally different accounts at two very different levels. Access denied for user 'mysql'@'localhost' (using password: NO) I can do this as super user or normal, and I can try passwords from earlier installations, but none of them work. So I am stopped dead in my tracks, am I not? That is because you didn't add this line to the [mysqld] section of your configuration file before you started mysqld. skip-grant-tables If you had, you would not have needed to use any passwords at all. This command (on the system prompt) would be all you need to connect to your now completely-unlocked database server (see the third section of generic instructions that work on any platform). mysql As for the datadir, the command update db locate mysql works on the Mac and gives me info about a whole set of files in /usr/local/mysql-5.1.73-osx10.6-x86_64. That's where I thought it was, and I deleted a previous installation because I had moved the data I needed to another machine. I'm 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. The door is there, you just just need to be able to see it as a door. Just a little more experience working on the command line will help. ... remainder snipped ... -- Shawn Green MySQL Senior Principal Technical Support Engineer Oracle USA, Inc. - Integrated Cloud Applications Platform Services Office: Blountville, TN Become certified in MySQL! Visit https://www.mysql.com/certification/ for details. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
password problem
I have installed mysql 5.1.73 on an old Mac Pro running OS Lion. I cannot run the mysql command because it challenges me for a password. But I did not set any password, either for the root, for mysql, or for myself as a user. So the installation has somehow installed passwords about which I know nothing or there is some error in the installation process. There is a lot on the Web about resetting a forgotten password. But the assumption is always that you can get at the program via some other password. But in this case every door is shut. Does anybody recognize this problem? I've 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
installation problem of MySQL on OS Lion
I installed MySQL on a Mac Pro running OS Lion. The installation was successful, but starting the mysql server generated the following error message: Martin-Muellers-Mac-Pro:~ martin$ sudo /usr/local/mysql/support-files/mysql.server start Starting MySQL ... ERROR! Manager of pid-file quit without updating file. I'll be grateful for any help Martin Mueller Professor emeritus of English and Classics Northwestern University
Re: create_time
So, if you want to have a permanent record of when a table was created‹never mind subsequent adjustments, you should personally enter the data as a table comment? On 5/4/15, 9:13 AM, Johan De Meersman vegiv...@tuxera.be wrote: ...sigh. That sounds logical. I have, however, also had Martin's experience where create_time seemed improbable; and the structure is unlikely to have changed without my knowledge as user accounts don't have DML privileges. I didn't pay any further attention to it, though, as it wasn't important to me at the time. I'll be monitoring this thread with interest :-) - 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, however, also had Martin's experience where create_time seemed improbable; -- Unhappiness is discouraged and will be corrected with kitten pictures. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: create_time
That’s not quite an answer to the question I asked. Does “create_time” represent the date at which a table was created, and does that date change or stay the same if there is an update on the table or columns are removed or added? I had an experience where a table that I knew to be several 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...@northwestern.edumailto:martinmuel...@northwestern.edu Cc: mysql@lists.mysql.commailto:mysql@lists.mysql.com mysql@lists.mysql.commailto:mysql@lists.mysql.com Subject: Re: create_time Hi Martin, which table are you looking at from information_schema? TABLES table should give you the correct information based on CREATE_TIME column, also if you check for show table status like 'table_name'; gives you the right information. On Fri, May 1, 2015 at 3:12 AM, Martin Mueller martinmuel...@northwestern.edumailto:martinmuel...@northwestern.edu wrote: 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 way of finding the date when a table was first created? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql -- Thanks, Trimurthy P Mobile : +91 97397 64298 http://mysqlinternals.blogspot.in/ https://www.linkedin.com/pub/trimurthy-pothanaboyina/5a/9a9/96b
create_time
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 way of finding the date when a table was first created? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
time stamp specific to columns
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 columns. Is there a command that says ³update the time stamp if and only if there is a change in columns a, b,c, or d -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
update and control flow
I'm trying to get my feet wet with 'if' and 'when' uses in mysql. it would be very useful for update operations, but I can't get it right. If I read the documentation correctly, it should be possible to say something like UPDATE X if WORD like 'a%' SET COMMENT = 'a' elseif WORD like 'b%' SET 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
Re: unicode case insensitive but diacritics sensitive
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 one that I know of, converting it to latin1 for the grouping works for that particular use case, but I can't make any promises how it'd work on your entire set which may hold any unicode character, a lot of which cannot be converted to latin1: mysql SET NAMES utf8; Query OK, 0 rows affected (0.00 sec) mysql CREATE TABLE test ( foo VARCHAR(3)) ENGINE=InnoDB COLLATE=utf8_bin; Query OK, 0 rows affected (0.14 sec) mysql SELECT GROUP_CONCAT(foo) FROM test GROUP BY foo; Empty set (0.00 sec) mysql INSERT INTO test VALUES ('Ete'),('été'),('ete'); Query OK, 3 rows affected (0.05 sec) Records: 3 Duplicates: 0 Warnings: 0 mysql SELECT *, GROUP_CONCAT(foo) FROM test GROUP BY foo; +---+---+ | foo | GROUP_CONCAT(foo) | +---+---+ | Ete | Ete | | ete | ete | | été | été | +---+---+ 3 rows in set (0.00 sec) mysql SELECT *, GROUP_CONCAT(foo) FROM test GROUP BY foo COLLATE utf8_general_ci; +--+---+ | foo | GROUP_CONCAT(foo) | +--+---+ | Ete | Ete,été,ete | +--+---+ 1 row in set (0.00 sec) mysql SELECT *, GROUP_CONCAT(foo) FROM test GROUP BY CONVERT(foo USING latin1) COLLATE latin1_general_ci; +---+---+ | foo | GROUP_CONCAT(foo) | +---+---+ | Ete | Ete,ete | | été | été | +---+---+ 2 rows in set (0.00 sec If you entire dataset fits in latin1, creating the table as such might be the best solution in this case entirely, depending on the environment. Another option is just to use utf8_bin as collation, but grouping by LOWER(yourcolumnname), or if that's not enough performance, denormalizing into an extra lowercase column. On Mon, Nov 24, 2014 at 11:36 PM, Martin Mueller martinmuel...@northwestern.edu wrote: 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 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
unicode case insensitive but diacritics sensitive
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 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
table comments
The TABLES table in MySQL's information_schema has a TABLE_COMMENT column. Could one use that for ad hoc and manual annotation of that table? And if so, could one change its length? Or are there better ways of producing table notes that are kept with the database, as opposed to Evernote or some notebook where you never find it again? Martin Mueller Professor emeritus of English and Classics Northwestern University
Re: Uninstall MySql Service
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 server * sudo rm /usr/local/mysql * sudo rm -rf /usr/local/mysql* * sudo rm -rf /Library/StartupItems/MySQLCOM * sudo rm -rf /Library/PreferencePanes/My* * edit /etc/hostconfig and remove the line MYSQLCOM=-YES- * rm -rf ~/Library/PreferencePanes/My* * sudo rm -rf /Library/Receipts/mysql* * sudo rm -rf /Library/Receipts/MySQL* * sudo rm -rf /private/var/db/receipts/*mysql* Perhaps it will work with Windows, mutatis mutandis On 11/19/11 12:29 AM, AndrewMcHorney andrewmchor...@cox.net wrote: Hello I want to completely reinstall my sql server due to prior install issues. How can you uninstall the MySql service? I am running under window 7. Andrew -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=martin.muel...@mac.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
how do I make utf8 the default encoding for my MySQL installation
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′ default-character-set=utf8 character-set-server=utf8 collation-server=utf8_general_ci skip-character-set-client-handshake On a Mac with MySQL 5.5.17 this produces the error [ERROR] /usr/local/mysql/bin/mysqld: unknown variable 'default-character-set=utf8' The Reference Manual is very tortuous but lacks instructions that are clear to a not very technical user. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
MySQL install on OS X Lion does not create root account
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 and uninstall routines, using the instructions by Rob Allen at (http://akrabat.com/computing/uninstalling-mysql-on-mac-os-x-leopard/) about:blank . I also followed various instructions in the MySQL documentation for resetting lost passwords. But the results persuaded me that the problem is something else: the installer does not create a root account or a mysql account in the user table. Thus the update command for resetting the root password executes correctly but update 0 rows. And logging in with the skip-grants-table lets you address some queries to the mysql user table. Select count(user) from user returns 0, as does select user, password from user. So it appears that the installation routine (from the disk image) does not populate the user table with accounts from which you could then perform other activities. Does anybody have any idea what is going on here or what I could be doing wrong?
problem with installing MySQL 5.5 on OS Lion
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 an empty set. This squares with the following finding. I had thought that lost passwords caused problems and ran the procedure for updating the root password that is set forth in the MySQL documentation. The procedure executes, except that it says that 0 rows were updated. So I assume that the user account root does not exist on the machine. There is a mysql user account on my Mac, but there may not be a mysql user entry in the user table. If I try to connect to the server with the mysql command when the server is started in the ordinary fashion I get the error message Access denied for user 'martin'@'localhost' (using password: NO) ditto for commands like mysql p u root mysql u root and the like. I should add that I followed Rob Allen's instructions for completely uninstalling previous versions, and theoretically speaking there should be no traces of earlier passwords on my system. But I'm not sure. I should add that I also followed the Post-installation steps inPaul Dubois's MySQL, and I noticed something odd. According to him, if you have a .tar package you need to run the mysql_install_db script. If you have a .dmg package, the installer runs it for you. When the .dmg package had the problems I described above, I tried a fresh installation from the .tar package. But the command bin/mysql_install_db user=mysql does not work , and in fact there is no script by that name in the /usr/local/mysql/bin directory. In short, in my installation there seems a gap between mysql and mysql, and I can't find any good explanations for what I might have done wrong or how I could fix it. I'll be grateful for any help.