Thor, this is what I get:
Code:
root@Nas:~# mysqladmin -u root password 'sometext';
mysqladmin: Can't turn off logging; error: 'Access denied; you need the SUPER privilege for this operation'
root@Nas:~#
The mysql_install_db script wants to create tables named db, host, user, func, tables_priv and about 13 more. None of these show up after it is run. Surely MySQL must have its own database to keep track of administrative stuff.
This is the current state of things after trying various things including those suggested above. Endless 'permission denied', 'access denied', or missing privilege. I cannot create a user or change password.
Code:
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| test |
+--------------------+
2 rows in set (0.00 sec)
mysql> use information_schema;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> show tables;
+---------------------------------------+
| Tables_in_information_schema |
+---------------------------------------+
| CHARACTER_SETS |
| COLLATIONS |
| COLLATION_CHARACTER_SET_APPLICABILITY |
| COLUMNS |
| COLUMN_PRIVILEGES |
| KEY_COLUMN_USAGE |
| ROUTINES |
| SCHEMATA |
| SCHEMA_PRIVILEGES |
| STATISTICS |
| TABLES |
| TABLE_CONSTRAINTS |
| TABLE_PRIVILEGES |
| TRIGGERS |
| USER_PRIVILEGES |
| VIEWS |
+---------------------------------------+
16 rows in set (0.00 sec)
mysql> select * from USER_PRIVILEGES;
+----------------+---------------+----------------+--------------+
| GRANTEE | TABLE_CATALOG | PRIVILEGE_TYPE | IS_GRANTABLE |
+----------------+---------------+----------------+--------------+
| ''@'localhost' | NULL | USAGE | NO |
+----------------+---------------+----------------+--------------+
1 row in set (0.00 sec)
mysql>