I once had a hope that my first article here would be to help someone. Not so. My current problem seem so simple that I must have missed something. I have spent a lot of time fooling around and searching/reading the forums here (and www.mysql.com as well as the INET in general) without finding a solution, so here it goes:
I have been using Open SUSE (my first Linux ever) since shortly prior to the 11.3 release, so my first proper installation was using 11.3. I have since successfully been setting up several Open Suse 11.3 LAMP-ish) with Joomla! and some more, along with Desktop variants. (Not yet hard-core production sites, though). All have been working properly as far as I can see (Thanks everybody on the forums here, and - in my case - SWERDNA in particular, for your good tutorials! They are a fine mix of examples, explanations and concepts to make even a beginner making a few educated decisions!). There is, however, still some miles to go until I feel as home with (Open SUSE) Linux as I am with Windows (I have been doing M$ for years). As of now, I am mostly working through Yast, executing a command using BASH now and then. I am learning.
I am unable to login to MySQL installed under 11.4. I did have some problems with 11.3 as well, but there I found that install it - then REMOVE it after activating the “Options” -> “Cleanup when deleting packages” inside Yast Software Manager - would allow me to reinstall MySQL and subsequently successfully run “mysql_install_db” and “mysql_secure_installation”. Following that, I could login to MySQL. The same procedure does not work with 11.4.
The installations are clean 11.4 installs from the DVD using KDE/EXT4. All installations are “minimum” installations. Which only mean I do not select anything at first, I install from Yast, and I do not modify or change any repositories. All installations seem to work fine apart from me not being able to login to MySQL.
The equipment used for testing 11.4 is:
VMWare ESXi 4.0. 64 bit, 50GB disk, 1GB RAM, 1 CPU core at 2.6GHz, two LAN adapters. Most Desktop-pattern entries and games were deselected during installation (Office and Graphics was deselected, and most of Multimedia).
A 6 year old Fujitsu-Siemens H230 laptop. 2GHz Intel Pentium Mobile single core, 32-bit, 2GB RAM, 12GB disk, two LAN adapters where the first is copper, the other is wireless (it works, but needs a delayed restart - which was not necessary under 11.3)) where 11.4 is dual-booting (GRUB) with Windows XP on a 80GB (total) disk.
Lenovo ThinkPad SL510. 64-bit, Intel dual-core at 2.2GHz, 4GB RAM, 120GB disk, two LAN adapters where the first is copper, the other is wireless (which doesn’t work, but this is not a 11.4 fault. There is no driver released for this WiFi adapter yet, and I cannot get the test-release to work. I’m not sure whether that is my fault or not. I’ll make a posting when I get it to work). Here, 11.4 is dual-booting with a 32-bit Windows 7 (using GRUB) on a 320GB (total) disk.
The behavior is consistent over all three environments.
After a (according to Yast) successful installation of MySQL, I execute “mysql_install_db” and start MySQL using “rcmysql start”. The deamon starts successfully, but I cannot login. I try the trick mentioned above, REMOVE MySQL and making sure the “Options” -> “Cleanup when deleting packages” inside the Yast Software Manager. Any dependent packages are modified to not use MySQL. (This may hamper some packages, but those I use are (to be) reinstalled after getting MySQL to work, the others are left as is. I do not check them.)
Here’s the details from executing “mysql_install_db”:
linux-host:/home/usr # **mysql_install_db** Installing MySQL system tables... 110606 0:18:28 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead. OK Filling help tables... 110606 0:18:29 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead. OK PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! To do so, start the server, then issue the following commands: /usr/bin/mysqladmin -u root password 'new-password' /usr/bin/mysqladmin -u root -h linux-host.site password 'new-password' Alternatively you can run: /usr/bin/mysql_secure_installation which will also give you the option of removing the test databases and anonymous user created by default. This is strongly recommended for production servers. See the manual for more instructions. You can start the MySQL daemon with: rcmysql start You can test the MySQL daemon with mysql-test package Please report any problems with the /usr/bin/mysqlbug script! linux-host:/home/usr # **rcmysql start** Will update MySQL now, if you encounter any problems, please read following file: /usr/share/doc/packages/mysql-community-server/README.SuSE Running protected MySQL... Upgrading MySQL... Looking for 'mysql' as: /usr/bin/mysql Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck This installation of MySQL is already upgraded to 5.1.53, use --force if you still need to run mysql_upgrade Starting service MySQL done linux-host:/home/usr # **/usr/bin/mysql_secure_installation** NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MySQL SERVERS IN PRODUCTION USE! PLEASE READ EACH STEP CAREFULLY! In order to log into MySQL to secure it, we'll need the current password for the root user. If you've just installed MySQL, and you haven't set the root password yet, the password will be blank, so you should just press enter here. Enter current password for root (enter for none): ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) Enter current password for root (enter for none): ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) Enter current password for root (enter for none): ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) Enter current password for root (enter for none): ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) Enter current password for root (enter for none): Aborting! Cleaning up... linux-host:/home/usr # **/usr/bin/mysqladmin -u root password zyka5f1ip** /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using password: NO)'
A similar thing happens if I try logging in using MySQL Workbench.
What am I missing here? Did MySQL as installed off the DVD get a default root-password I am not aware of? Can anybody help?