Version 5 Development > Plugin Design

mysql 5.1.56 Plugin for unRAID 5b11+

<< < (2/12) > >>

ajax3712:
It did not say that it's running so here's the contents of the *.err file...


--- Code: ---111007 11:57:15 mysqld_safe Starting mysqld daemon with databases from /mnt/cache/_mysql
111007 11:57:15 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
/usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist
111007 11:57:15 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
/usr/libexec/mysqld: Can't create/write to file '/tmp/ibT942Ci' (Errcode: 13)
111007 11:57:15  InnoDB: Error: unable to create temporary file; errno: 13
111007 11:57:15 [ERROR] Plugin 'InnoDB' init function returned error.
111007 11:57:15 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
111007 11:57:15 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
111007 11:57:15 mysqld_safe mysqld from pid file /var/run/mysql/mysql.pid ended

--- End code ---

SeeDrs:

--- Quote from: ajax3712 on October 07, 2011, 11:02:45 AM ---It did not say that it's running so here's the contents of the *.err file...


--- Code: ---111007 11:57:15 mysqld_safe Starting mysqld daemon with databases from /mnt/cache/_mysql
111007 11:57:15 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
/usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist
111007 11:57:15 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
/usr/libexec/mysqld: Can't create/write to file '/tmp/ibT942Ci' (Errcode: 13)
111007 11:57:15  InnoDB: Error: unable to create temporary file; errno: 13
111007 11:57:15 [ERROR] Plugin 'InnoDB' init function returned error.
111007 11:57:15 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
111007 11:57:15 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
111007 11:57:15 mysqld_safe mysqld from pid file /var/run/mysql/mysql.pid ended

--- End code ---

--- End quote ---

I'm pretty sure I fugued out the problem. I uploaded a updated version in the OP.  first step is to delete the /mnt/cache/_mysql directory that has been partially created by the previous install before installing the new version.

ajax3712:
Thanks so much for the quick help, btw.  

I installplg'd the new version and things appeared to work.  I got the "mysql is running notice" and no longer get the "can't connect" error message.

However, when I now try to connect using mysql -u root -p, I get the following error after entering my password:


--- Code: ---ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

--- End code ---

(Updated to attach the *.err file, renamed *.txt)

ajax3712:
And I should note that although I did change my password from what was supplied as default, it is (at least initially) a very simple password, all letters + 1 number...

using the new password and the original/default password returns the same error for me...

SeeDrs:

--- Quote from: ajax3712 on October 07, 2011, 12:03:12 PM ---And I should note that although I did change my password from what was supplied as default, it is (at least initially) a very simple password, all letters + 1 number...

using the new password and the original/default password returns the same error for me...

--- End quote ---

follow these steps to reinstall mysql with a new root password. This will not save any current data in the database.

1. goto mysql settings screen, set enable service to no, click apply. Now it should say mysql is not running.
2. delete the _mysql folder in /mnt/cache
3. go back to the my sql settings screen set enable service to yes. click apply.

Now try to logon using the initial root password that you have set in the settings screen.  Once that password is set during the initial install, it can only be change by connecting to the mysql server and doing it there.

Navigation

[0] Message Index

[#] Next page

[*] Previous page