MySQL Bugs: #68565: We are trying to Install Mysql on our Sun OS sparc but facing installation issue

Bug #68565	We are trying to Install Mysql on our Sun OS sparc but facing installation issue
Submitted:	4 Mar 2013 21:21	Modified:	18 Mar 2013 17:06
Reporter:	Dharam bhat	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Installing	Severity:	S3 (Non-critical)
Version:	mysql-5.6.10-solaris10-sparc-64bit	OS:	Solaris (SunOS wswebddal1 5.10 Generic_147440-25 sun4v sparc SUNW,Sun-Fire-T200)
Assigned to:		CPU Architecture:	Any

Description:
We are trying to do this installtion using a non root user and have created folder /apps/mysql5.6/ for installation after downloading mysql-5.6.10-solaris10-sparc-64bit.

Tried running ./scripts/mysql_install_db both with and without options and are getting these errors
 ./scripts/mysql_install_db --no-defaults -- basedir = /apps/mysql5.6/mysql-5.6.10-solaris10-sparc-64bit -- datadir= /apps/mysql5.6/mysql-5.6.10-solaris10-sparc-64bit/data -- builddir = /apps/mysql5.6/mysql-5.6.10-solaris10-sparc-64bit -- srcdir = /apps/mysql5.6/mysql-5.6.10-solaris10-sparc-64bit -- ldata = /apps/mysql5.6/mysql-5.6.10-solaris10-sparc-64bit/data

2013-03-04 16:17:06 26155 [Note] InnoDB: 1.2.10 started; log sequence number 1601503
./bin/mysqld: Too many arguments (first extra is 'basedir').

While trying to run without any arguments, we get

2013-03-04 16:18:41 26208 [Note] InnoDB: 1.2.10 started; log sequence number 1601513
ERROR: 1034  Incorrect key file for table 'db'; try to repair it

Also, we tried to by pass this script and directly start the daemon like below
but get errors there as well.
./mysqld -b, --basedir=/apps/mysql5.6/mysql-5.6.10-solaris10-sparc-64bit --datadir=/apps/mysql5.6/mysql-5.6.10-solaris10-sparc-64bit/data

./mysqld: Table 'mysql.plugin' doesn't exist
2013-03-04 16:19:54 26245 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.

2013-03-04 16:19:55 26245 [Note] Server hostname (bind-address): '*'; port: 3306
2013-03-04 16:19:55 26245 [Note] IPv6 is available.
2013-03-04 16:19:55 26245 [Note]   - '::' resolves to '::';
2013-03-04 16:19:55 26245 [Note] Server socket created on IP: '::'.
2013-03-04 16:19:55 26245 [ERROR] Fatal error: Can't open and lock privilege tables: Incorrect key file for table 'user'; try to repair it
[]/apps/mysql5.6/mysql-5.6.10-solaris10-sparc-64bit/bin>

How to repeat:
Bugs can be repeated by trying to install mysql-5.6.10-solaris10-sparc-64bit

I think you need to invoke the mysql_install_db script with "--basedir=/apps/mysql5.6/mysql-5.6.10-solaris10-sparc-64bit ....", that is, with the options and arguments written without spaces.

If I try something like

./scripts/mysql_install_db --no-defaults -- basedir = <basedir>

instead of 

./scripts/mysql_install_db --no-defaults --basedir=<basedir>

then I see the same behaviour as you do.

Please try out the above suggestion.

Hi Erlend,
First thanks for your response!

Actaully i was able to complete the installation after removing spaces and defining some environment variables like PATH and TMP_DIR.

However,I did all installation using non root user and i am able to run below.
mysql> select curtime()
    -> ;
+-----------+
| curtime() |
+-----------+
| 15:48:34  |
+-----------+
1 row in set (0.00 sec)

But,i am getting access denied for other sytem tables like user etc.
Is it necessary to login as a root to set up all users or is there a workaround?

Also, i am trying to find a document to understand where to name/catalog this DB
so we can connect through clinets as well with user accounts likewe do in oracle or Db2.

I would refer you to "User Names and Passwords" in

  http://dev.mysql.com/doc/refman/5.6/en/user-names.html

Please note that MySQL account names (like the initial "root") have nothing to do with Unix login names.

Hi Erlend,

I am able to do below and can see i am logged on to mysql with the default user that i used for installation.Also i am able to run sysdate etc queries,so that part is working.

mysql> select user();
+-------------------+
| user()            |
+-------------------+
| abcadm@localhost |
+-------------------+

But when i try to set up this user or any other ,i am getting access denied error.

mysql> select * from mysql.db;
ERROR 1142 (42000): SELECT command denied to user ''@'localhost' for table 'db'
mysql> select * from mysql.user;
ERROR 1142 (42000): SELECT command denied to user ''@'localhost' for table 'user'
So this is becoming chichkena nd egg issue for me.I know i need to set up users/passwords but not sure how to get access in first place to my default user.

Please help!

Works now after using root user .