nicht angemeldet
flus privileges <=> neustart vom mysql dienst???
so root pass gesetzt. config im skript angepasst. immernoch kein zugang.
anbei mal was so inb der mysql db steht.
ich hab ehrlich gesagt kein elust mehr ^^ so schwer kanns doch net sein... :-)
+-----------------------+-----------------------------------+----
---+-------+
| Field | Type | Nul
lt | Extra |
+-----------------------+-----------------------------------+----
---+-------+
| Host | char(60) | NO
| |
| User | char(16) | NO
| |
| Password | char(41) | NO
| |
| Select_priv | enum('N','Y') | NO
| |
| Insert_priv | enum('N','Y') | NO
| |
| Update_priv | enum('N','Y') | NO
| |
| Delete_priv | enum('N','Y') | NO
| |
| Create_priv | enum('N','Y') | NO
| |
| Drop_priv | enum('N','Y') | NO
| |
| Reload_priv | enum('N','Y') | NO
| |
| Shutdown_priv | enum('N','Y') | NO
| |
| Process_priv | enum('N','Y') | NO
| |
| File_priv | enum('N','Y') | NO
| |
| Grant_priv | enum('N','Y') | NO
| |
| References_priv | enum('N','Y') | NO
| |
| Index_priv | enum('N','Y') | NO
| |
| Alter_priv | enum('N','Y') | NO
| |
| Show_db_priv | enum('N','Y') | NO
| |
| Super_priv | enum('N','Y') | NO
| |
| Create_tmp_table_priv | enum('N','Y') | NO
| |
| Lock_tables_priv | enum('N','Y') | NO
| |
| Execute_priv | enum('N','Y') | NO
| |
| Repl_slave_priv | enum('N','Y') | NO
| |
| Repl_client_priv | enum('N','Y') | NO
| |
| Create_view_priv | enum('N','Y') | NO
| |
| Show_view_priv | enum('N','Y') | NO
| |
| Create_routine_priv | enum('N','Y') | NO
| |
| Alter_routine_priv | enum('N','Y') | NO
| |
| Create_user_priv | enum('N','Y') | NO
| |
| ssl_type | enum('','ANY','X509','SPECIFIED') | NO
| |
| ssl_cipher | blob | NO
| |
| x509_issuer | blob | NO
| |
| x509_subject | blob | NO
| |
| max_questions | int(11) unsigned | NO
| |
| max_updates | int(11) unsigned | NO
| |
| max_connections | int(11) unsigned | NO
| |
| max_user_connections | int(11) unsigned | NO
| |
+-----------------------+-----------------------------------+----
---+-------+
37 rows in set (0.01 sec)
mysql> select user, host, password from user;
+------+-----------+-------------------------------------------+
| user | host | password |
+------+-----------+-------------------------------------------+
| root | localhost | *71BB870DD362991035C3CF8A3EDE8DBD2ADE2A05 |
| root | 127.0.0.1 | |
| | localhost | |
+------+-----------+-------------------------------------------+
Hello,
der user root hat auch zugriff auf alle db's.. meine all privileges...
Was sagen die Tabellen der Datenbank mysql?
Hier ein Beispiel eines gerade installierten und noch nicht mit Root-Passwort gesicherten lokalen Testsystems _ohne_ phpMyAdmin
mysql> use mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -ADatabase changed
mysql> show columns from users;
ERROR 1146 (42S02): Table 'mysql.users' doesn't exist
mysql> show columns from user;
+-----------------------+-----------------------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------------------+-----------------------------------+------+-----+---------+-------+
| Host | char(60) | NO | PRI | | |
| User | char(16) | NO | PRI | | |
| Password | char(41) | NO | | | |
| Select_priv | enum('N','Y') | NO | | N | |
| Insert_priv | enum('N','Y') | NO | | N | |
| Update_priv | enum('N','Y') | NO | | N | |
| Delete_priv | enum('N','Y') | NO | | N | |
| Create_priv | enum('N','Y') | NO | | N | |
| Drop_priv | enum('N','Y') | NO | | N | |
| Reload_priv | enum('N','Y') | NO | | N | |
| Shutdown_priv | enum('N','Y') | NO | | N | |
| Process_priv | enum('N','Y') | NO | | N | |
| File_priv | enum('N','Y') | NO | | N | |
| Grant_priv | enum('N','Y') | NO | | N | |
| References_priv | enum('N','Y') | NO | | N | |
| Index_priv | enum('N','Y') | NO | | N | |
| Alter_priv | enum('N','Y') | NO | | N | |
| Show_db_priv | enum('N','Y') | NO | | N | |
| Super_priv | enum('N','Y') | NO | | N | |
| Create_tmp_table_priv | enum('N','Y') | NO | | N | |
| Lock_tables_priv | enum('N','Y') | NO | | N | |
| Execute_priv | enum('N','Y') | NO | | N | |
| Repl_slave_priv | enum('N','Y') | NO | | N | |
| Repl_client_priv | enum('N','Y') | NO | | N | |
| Create_view_priv | enum('N','Y') | NO | | N | |
| Show_view_priv | enum('N','Y') | NO | | N | |
| Create_routine_priv | enum('N','Y') | NO | | N | |
| Alter_routine_priv | enum('N','Y') | NO | | N | |
| Create_user_priv | enum('N','Y') | NO | | N | |
| ssl_type | enum('','ANY','X509','SPECIFIED') | NO | | | |
| ssl_cipher | blob | NO | | NULL | |
| x509_issuer | blob | NO | | NULL | |
| x509_subject | blob | NO | | NULL | |
| max_questions | int(11) unsigned | NO | | 0 | |
| max_updates | int(11) unsigned | NO | | 0 | |
| max_connections | int(11) unsigned | NO | | 0 | |
| max_user_connections | int(11) unsigned | NO | | 0 | |
+-----------------------+-----------------------------------+------+-----+---------+-------+
37 rows in set (0.01 sec)mysql> select user, host, password from user;
+------------------+-----------+-------------------------------------------+
| user | host | password |
+------------------+-----------+-------------------------------------------+
| root | localhost | |
| root | debian4 | |
| root | 127.0.0.1 | |
| | localhost | |
| | debian4 | |
| debian-sys-maint | localhost | *B67A73CE1E6FD97E3E79FD333AD784005D321A17 |
| mailadmin | localhost | *7684C7596CA32C6BCFA32EBDBD3BF7B4A841E46F |
| maildaemon | localhost | *A41FA06283CBD4BF634452EF1EE00406596B4D93 |
+------------------+-----------+-------------------------------------------+
8 rows in set (0.00 sec)mysql>
Wenn Du Konsolenzugang hast, sollte es kein Problem sein, das Problem zu lösen.
Liebe Grüße aus Syburg bei Dortmund
Tom vom Berg
