Portál AbcLinuxu, 12. května 2025 19:19
[root@localhost init.d]# ./mysqld status [root@localhost init.d]# [ OK ]
[root@localhost init.d]# mysqld_safe nohup: ignoring input and redirecting stderr to stdout PID TTY STAT TIME COMMAND 8636 pts/1 Sl 0:00 /usr/sbin/mysqld --skip-grant A mysqld process already exists
[root@localhost mysql]# pwd /var/lib/mysql [root@localhost mysql]# ls ibdata1 ib_logfile0 ib_logfile1 localhost.err mysql/ mysqlmanager.sock= mysql.sock= test/
[root@localhost init.d]# mysqladmin ping mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using password: NO)'
[root@localhost init.d]# mysqladmin -u root password mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using password: NO)
# Example MySQL config file for medium systems. # # This is for a system with little memory (32M - 64M) where MySQL plays # an important part, or systems up to 128M where MySQL is used together with # other programs (such as a web server) # # The following options will be passed to all MySQL clients [client] user = root #password = your_password port = 3306 socket = /var/lib/mysql/mysql.sock # Here follows entries for some specific programs # The MySQL server [mysqld] user = mysql datadir = /var/lib/mysql port = 3306 socket = /var/lib/mysql/mysql.sock pid-file = /var/run/mysqld/mysqld.pid skip-locking key_buffer = 16M max_allowed_packet = 1M table_cache = 64 sort_buffer_size = 512K net_buffer_length = 8K read_buffer_size = 256K read_rnd_buffer_size = 512K myisam_sort_buffer_size = 8M collation_server = utf8_unicode_ci character_set_server = utf8 # Default to using old password format for compatibility with old and # shorter password hash. "/etc/my.cnf" [readonly] 190L, 5590CA precital som internet.
pytalo heslo: [root@localhost ~]# mysqladmin -u root password "ondro" mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using password: NO)' [root@localhost ~]# mysql -u root -p Enter password: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) [root@localhost ~]#
[root@localhost ~]# mysql -u root -p Enter password: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)Nie je tam problem iny?
[root@localhost ~]# mysqladmin ping mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using password: NO)'Ak zadate ping co vypise Vam?
Doporučuji nejdříve heslo "vyresetovat" a to tak, že se spustí mysqld --skip-grant-tables - pote se to na heslo neptá, je možné se přihlásit pouze pomocí mysql.
uvnitř mysql pomocí
21.5.2008 08:16
UPDATE mysql.user SET Password=PASSWORD('mojenoveheslo') WHERE USER='root';
FLUSH PRIVILEGES;
Pozor co to zahlásí, jestli se něco změnilo, nebo ne, pokud se totiž podařilo uživatele root zcela smazat, no pak bude třeba je znovu vytvořit...
Přihlašování do mysql potom probíhá přes
mysql -u root -p
a to "-p" je tam velmi důležité, protože říká, že se má ptát po hesle. To je myslím i důvod, proč nefungoval příkaz mysqladmin, jak bylo psáno výše, protože už tam na rootu asi nějaké heslo je a -p tam potom chybí.
Dělal jsem to tak naposled včera, funguje to :) Zdroj: http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html
apache-mod_auth_mysqlA ani som heslo nemusel zadavat(bolo zadane), jednoducho
mysqladmin ping mysql is alive
27.5.2008 12:45
Pavel Stárek | skóre: 44
| blog: Tady bloguju já :-)
| Kolín
27.5.2008 16:55
Pavel Stárek | skóre: 44
| blog: Tady bloguju já :-)
| Kolín
shell> mysqld_safe --skip-grant-tables &
shell> mysqladmin flush-privileges password 'mypassword'
mysqladmin: unable to change password; error: 'Can't find any matching row
in the user table'
mysql> UPDATE user SET Password=PASSWORD('ondro') WHERE
Host='localhost' AND User='root';
Query OK, 0 rows affected (0.00 sec)
Rows matched: 0 Changed: 0 Warnings: 0
mysql> SELECT * from user WHERE User='root';
Empty set (0.00 sec)
mysql> use mysql
Database changed
mysql> show tables
-> ;
+---------------------------+
| Tables_in_mysql |
+---------------------------+
| columns_priv |
| db |
| func |
| help_category |
| help_keyword |
| help_relation |
| help_topic |
| host |
| proc |
| procs_priv |
| tables_priv |
| time_zone |
| time_zone_leap_second |
| time_zone_name |
| time_zone_transition |
| time_zone_transition_type |
| user |
| user_info |
+---------------------------+
18 rows in set (0.01 sec)
mysql> select * from user
-> ;
Empty set (0.00 sec)
[root@localhost ~]# mysql -u root -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
Este sa mi nepodarilo spustit
mysql_install_db
co moze byt problem, ako keby sa nevytvoril user root v tabulke user, alebo server nie je startnuty pod uzivatelom root?
Vazne neviem. Ja uz len vidim tu moznost ze na dalsiu particiu si hodit SLES a skusit to spojadnit tam. Co myslite?
28.5.2008 12:54
Pavel Stárek | skóre: 44
| blog: Tady bloguju já :-)
| Kolín
[root@localhost ~]# mysqld_safe nohup: ignoring input and redirecting stderr to stdout PID TTY STAT TIME COMMAND 2939 ? Sl 0:00 /usr/sbin/mysqld --no-defaults --user=mysql --datadir=/var/lib/mysql --port=3306 --socket=/var/lib A mysqld process already exists [root@localhost ~]# mysqladmin ping mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using password: NO)'Dakujem za navod vsetko som odinstaloval a postupoval podla navodu. Nepomohlo, navod je bud zly alebo to mne nefunguje. Inac je zaujimave ten vypis vyssie. Startnem si mysqld_safe a oni mi to vypise ze mi tam mysql nebezi tak kde potom bezi ked nie na localhoste?
30.5.2008 15:08
Pavel Stárek | skóre: 44
| blog: Tady bloguju já :-)
| Kolín
linux-compaq:/etc/rc.d # mysqladmin ping mysqld is alive linux-compaq:/etc/rc.d # mysqladmin -u root password sykora linux-compaq:/etc/rc.d # mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 4 to server version: 5.0.26 Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | mysql | | test | +--------------------+ 3 rows in set (0.01 sec) mysql> exit Bye linux-compaq:/etc/rc.d #tak sme to vyriesili ;--)
Tiskni
Sdílej:
ISSN 1214-1267, (c) 1999-2007 Stickfish s.r.o.