Dakle juce sam instaliraod MySQL 4.1.1 cinimi se i odmah mi se pojavio problem ne znam koji je default pass. Googlao sam malo i pu naso da bi rebao da je blank medjutim nije.
Pokusao sam da ga promenim ovako medjutim nije mi uspelo (koristio sam blank (dakle samo enter) onda pass za root korisnika onda pass za mysql korisnika medjurim nista nije prihvatao)
Onda sma naso na netu upuctvo za reset pass- ali i ono izgleda ne radi
ps aux | grep mysql
Napominjem da sam instalirao rpm-ove a ne iz sorsa ako ima neke razlike?
Dakle kako da resetujem pass??
Pokusao sam da ga promenim ovako medjutim nije mi uspelo (koristio sam blank (dakle samo enter) onda pass za root korisnika onda pass za mysql korisnika medjurim nista nije prihvatao)
Code:
VoID:~ # mysqladmin -u root -p password newpass
Enter password:
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'
VoID:~ # mysqladmin -u root -p password anotherpass
Enter password:
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'
VoID:~ # mysqladmin -u root -p password newpass
Enter password:
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'
VoID:~ # mysqladmin -u root -p password anotherpass
Enter password:
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'
Onda sma naso na netu upuctvo za reset pass- ali i ono izgleda ne radi
Code:
VoID:~ # mysqld --skip-grant-tables --user=root
060212 12:56:58 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
060212 12:56:58 [ERROR] Do you already have another mysqld server running on port: 3306 ?
060212 12:56:58 [ERROR] Aborting
060212 12:56:58 [Note] mysqld: Shutdown complete
VoID:~ # mysqld --skip-grant-tables --user=root
060212 12:56:58 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
060212 12:56:58 [ERROR] Do you already have another mysqld server running on port: 3306 ?
060212 12:56:58 [ERROR] Aborting
060212 12:56:58 [Note] mysqld: Shutdown complete
ps aux | grep mysql
Code:
VoID:~ # ps aux | grep mysql
root 17242 0.0 0.2 2672 1244 pts/1 S 12:55 0:00 /bin/sh /usr/bin/mysqld_safe --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --socket=/var/lib/mysql/mysql.sock --datadir=/var/lib/mysql
mysql 17276 0.2 2.9 57716 15348 pts/1 Sl 12:55 0:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --skip-locking --port=3306 --socket=/var/lib/mysql/mysql.sock
root 17294 0.0 0.1 1788 624 pts/1 R+ 12:57 0:00 grep mysql
VoID:~ #
VoID:~ # ps aux | grep mysql
root 17242 0.0 0.2 2672 1244 pts/1 S 12:55 0:00 /bin/sh /usr/bin/mysqld_safe --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --socket=/var/lib/mysql/mysql.sock --datadir=/var/lib/mysql
mysql 17276 0.2 2.9 57716 15348 pts/1 Sl 12:55 0:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --skip-locking --port=3306 --socket=/var/lib/mysql/mysql.sock
root 17294 0.0 0.1 1788 624 pts/1 R+ 12:57 0:00 grep mysql
VoID:~ #
Napominjem da sam instalirao rpm-ove a ne iz sorsa ako ima neke razlike?
Dakle kako da resetujem pass??