|
1) how can I check the log if MySQL isn't running?
2) I checked in Process viewer, and the mysqld is not located/running. I know it should be... 3) I don't think i changed the database 4) no, i don't have PHPMyAdmin |
Help after answer..
hi,
you don't need mysql running to check the log...I'm not talking about the query log, I'm talking about the ERROR log...and this file can be everywhere depending of your installation and/or/configuration. This is from the mysql website: Quote:
When you have the error log file...check the file with the following command: tail file.err and post the results in this thread... Secondo, Have you installed the StartupScript package from the Mark L. website? If yes, well, your mysql installation doesn't start for some reason! Did you upgrade your system lately? If yes, re-install the startupscript. If you didn't install the StartupScript, try to start the mysqld from a terminal window with a command like this one : "sudo /usr/local/mysql/bin/mysqld_safe &" check the processviewer after that... if mysqld is not running...you have a problem with your mysql config. Finally, an utility like PHPMyAdmin can be useful to track problems and manage your database...but it is not usefull in your case right now...because mysqld is not even running so PHPMyAdmin is not going to work anyway... Hope that help...i'm not so far if you need more help... |
GOT IT
i installed another startup script package. that took care of the problem!
thanks! ok, I downloaded PHPMyAdmin... I'll load it and check it out... but whats the difference between using: SQL Boss FileMakerPro 6 CocoaMySQL YourSQL PHPMyAdmin ??? thanks td6 |
<<laughing>> ready to shake your head?? in the terminal its says "Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 3.23.53-entropy.ch" and in the pref pane, it says version 4.0.12 running... I trust the terminal... i guess i'll update to completeMySQL version 4. T |
Differences
hi,
Mmmm....well...I can tell you what are the big lines for each of them, but I never used them all. So, I'll try to do my best! All these softwares are use for the same thing...manage database. YourSQL is a GUI (Graphical user interface) app made for mac os x only...the author suggest CocoaMySQL for advanced features....;-) Only usefull with MySQL database type CocoaMySQL is a GUI app for mac os x only but the program is written in Cocoa. Much faster on mac os x since it use the power of Quartz and etc... but is about the same as YourSQL. SQLBoss is a commercial tool...$$$$...but it is also a GUI app and can be use on many OS like windows and mac. Can manage MySQL, ODBC, postgreSQL and a few more database type. FileMaker Pro is a commercial tool...$299.... It is not the same as MySQL...Filemaker is using its own type of database. You can import/export to/from SQL and ODBC database. PHPMyAdmin is only usefull with MySQL database. The biggest advantage of this utility is that you don't need a particular piece of software or client since this utility is running on the remote host. So, you can manage your database from everywhere and on every OS. You just need a browser with the Internet enabled! It's also free! They all do approximately the same task..choose the one you prefer or/and meet your needs. YourSQL and CocoaMySQL are maybe the most appropriate for you. It depend... Good luck! Vincent |
Hmmm... i don't understand...you log in the mysql server with your terminal and you saw 'version 3-23.53'...
you go in the pref panel and you saw version 4.0......fff! OK....! Well....I don't have mysql running on mac os x 10.2.5 and it must sound stupid but which pref panel are you? Are you talking about a software that we mention earlier? Because I don't use them...except PHPMyAdmin. I'm a freaky command line geek about *nix software... So, more info would be very appreciate! Bye |
"your MySQL connection id is 2 to server version: 3.23.53-entropy.ch"--that's what it says in the terminal... and in the MySQL pref pane, it says version 4.0.12: status: running... ????
i have it running ok on a g3 (10.2.5) where it says it's running 4.0.12 (both locations). I reinstalled the completeMySQL 4.0.12, and i get the same result...(on the g4) T |
upgrade??
Hi,
Did you upgrade your mysql version from 3.23-53 to 4.0.x before you had your problem? Because it is very strange...could be interesting to know what went wrong in this case.... Have a nice day Vincent |
I had upgraded to 4 prior to these problems... I have an idea... I'll check it out and let you know...
later T |
nevermind...I downloaded the standard 4 version and got it to update. I've been trying to use completeMySQL and that wasn't updating...
thanks for the info! T |
miller time
ok... i tried this...
mysql -u root -p test and i get this... ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES) so, i tried this... root# safe_mysqld & and i get this... root# The file /usr/local/mysql/libexec/mysqld doesn't exist or is not executable Please do a cd to the mysql installation directory and restart this script from there as follows: ./bin/mysqld_safe. when i type groups i get: staff mysql admin so i can't figure out why MySQL won't let me in? I know the mysqld is running, because I checked it in process viewer... |
Upgrade
OK....well did you do a command like this one when you re-installed mysql
Code:
mysqladmin -u root password new_password_hereAnd the safe_mysqld isn't working because it is not in your path... you have to type the full path to the script. Like this : Code:
sudo ./usr/local/mysql/bin/mysqld_safe &I highly suggest that you read the Marc Liyanage website Always there if you need.... -- Vincent |
| All times are GMT -5. The time now is 05:36 PM. |
Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.
Site design © IDG Consumer & SMB; individuals retain copyright of their postings
but consent to the possible use of their material in other areas of IDG Consumer & SMB.