Bug #41656 Impossible to login to mysql client after installation
Submitted: 20 Dec 2008 15:16 Modified: 7 Dec 2016 15:02
Reporter: Maxime Bégnis Email Updates:
Status: Unsupported Impact on me:
None 
Category:MySQL Server: Installing Severity:S3 (Non-critical)
Version:Ver 14.12 Distrib 5.0.67 OS:Linux (Mandriva 2009.0)
Assigned to: CPU Architecture:Any

[20 Dec 2008 15:16] Maxime Bégnis
Description:
after installation of mysql on my system, I can't log into the client:

---------------------------------
~]$ mysql -u root
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
---------------------------------

so I tried to install the initial db with no success:

---------------------------------
# mysql_install_db
Installing MySQL system tables...
ERROR: 1004  Can't create file '/root/tmp/#sql19e5_1_0.frm' (errno: 13)
081220 16:08:02 [ERROR] Aborting

081220 16:08:02 [Note] /usr/sbin/mysqld: Shutdown complete

Installation of system tables failed!

Examine the logs in /var/lib/mysql for more information.
You can try to start the mysqld daemon with:
/usr/sbin/mysqld --skip-grant &
and use the command line tool
/usr/bin/mysql to connect to the mysql
database and look at the grant tables:

shell> /usr/bin/mysql -u root mysql
mysql> show tables

Try 'mysqld --help' if you have problems with paths. Using --log
gives you a log in /var/lib/mysql that may be helpful.

The latest information about MySQL is available on the web at
http://www.mysql.com
Please consult the MySQL manual section: 'Problems running mysql_install_db',
and the manual section that describes problems on your OS.
Another information source is the MySQL email archive.
Please check all of the above before mailing us!
And if you do mail us, you MUST use the /usr/bin/mysqlbug script!
-------------------------------

I tried to give all possible access rights to '/root/tmp/' with no success.

Thanks if you can help.

How to repeat:
I don't know how to repeat this problem, sorry.
[21 Dec 2008 15:40] Valeriy Kravchuk
Thank you for a problem report. Had you used MySQL's binaries? (provide download URL used then, please) 

If you compiled from sources yourself, please, send the configure command line used.
[22 Dec 2008 19:12] Maxime Bégnis
Hi, I did a mistake I replyed to my own message yesterday. I guess it was lost. sorry.

I used binaries from the Mandriva 2009 ditribution when I got this bug.

After that I tried with the binaries supplied by this site:
"http://dev.mysql.com/get/Downloads/MySQL-5.1/MySQL-server-5.1.30-0.glibc23.i386.rpm/from/f..."
"http://dev.mysql.com/get/Downloads/MySQL-5.1/MySQL-client-5.1.30-0.glibc23.i386.rpm/from/f..."

Before installing the packages I set the environment variable TMPDIR:
shell> TMPDIR=/tmp/
shell> export TMPDIR

Since I had the error: "Can't create file '/root/tmp/#sql19e5_1_0.frm'".

And all worked fine then.
[23 Dec 2008 5:35] Valeriy Kravchuk
Had you tried MySQL's binaries of 5.0.67? I just want to know if this problem is still repeatable with 5.0.
[24 Jan 2009 0:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
[7 Dec 2016 15:02] Yngve Svendsen
Posted by developer:
 
This relates to EOL (no longer supported) versions of MySQL Server. Furthermore, the old plain msi installers have been superseded by the MySQL Installer for Windows. Thus closing.