well may be i ask wrong, i whant change the pass for phpmyadmin cant enter to the dbo and the mysql cant load the accounts, some change the pass and now cant load nothing T_T some knows where i can change this in the files, i can use winscp
Printable View
well may be i ask wrong, i whant change the pass for phpmyadmin cant enter to the dbo and the mysql cant load the accounts, some change the pass and now cant load nothing T_T some knows where i can change this in the files, i can use winscp
phpmyadmin is somewhere on your webserver. We cant know where you put it in.Quote:
Originally Posted by angelmx
To change the pass of your mysql itself check the file /etc/mysql/my.cfg ( or was it my.ini ? ) check the folder, there are not many files in it.
i find the phpmyadmin folder is located in var/www/Quote:
Originally Posted by Zorno
but i cant see for the password of the web phpmyadmin, i look for the mysql/my.cfg but is the same i cant see a password or user.
i cant enter to IP/phpMyAdmin
phpmyyadmin only has a password for the control user... which is not required
If you forgot the root password...
That is stored in the mysql database (the one named mysql on the server)
Run
UsingCode:mysql --no-defaults --bind-address=127.0.0.1 --bootstrap --console --skip-grant-tables --skip-innodb --standalone < resetroot.sql
As the resetroot.sqlCode:INSERT IGNORE INTO `user` VALUES ('localhost', 'root', '', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', '', '', '', '', 0, 0, 0, 0);
REPLACE INTO `user` VALUES ('localhost', 'root', '', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', '', '', '', '', 0, 0, 0, 0);
[QUOTE=das7002;6053501]phpmyyadmin only has a password for the control user... which is not required
If you forgot the root password...
That is stored in the mysql database (the one named mysql on the server)
Run
No such file or directory.Code:mysql --no-defaults --bind-address=127.0.0.1 --bootstrap --console --skip-grant-tables --skip-innodb --standalone < resetroot.sql
I dont forgot the pass T_T someone changed the pass for the web phpmyadmin, i can enter tho the server and wincp can load the files i see all file but the database cant be load, i just play fine but in a moment the character go off i go tho the pwAdmin and se in account and the accounts dont load, and cant enter in phpmyadmin: error 1045 acces denied for user root@localhost (using password yes)
Quote:
Originally Posted by angelmxNo such file or directory.Quote:
Originally Posted by das7002
I dont forgot the pass T_T someone changed the pass for the web phpmyadmin, i can enter tho the server and wincp can load the files i see all file but the database cant be load, i just play fine but in a moment the character go off i go tho the pwAdmin and se in account and the accounts dont load, and cant enter in phpmyadmin: error 1045 acces denied for user root@localhost (using password yes)
Can you not read? You need to make the resetroot.sql file like I gave you...
and "Access denied for user root@localhost" is the MYSQL password NOT phpMyAdmin's password as phpMyAdmin DOES NOT have a password specifically for it...
You forgot the MySQL password...
the password for root is the default: hrace009Quote:
Originally Posted by das7002
i use the release from hrace009 is only for a friends i dont be neccesary change the pass if only friends play whit my u.u
beliveme i dont forget the pass.
and use the resetroot.sql you posted and the error i say i think gona replace the folder mysql and phpmyadmin in the server i hope whit this can put the old password and gona changed now T_T
Why you use phpmyadmin anyway ?
I personally prefer Navicat. But ok, when you cannot access phpmyadmin maybe this helps you: Phpmyadmin password - PHWinfo
Any way i think i tooo noob for this i cant kill the mysql T_T in other question i doo a backup all the days, the backup from the pwAdmin can have all dates? i think is more fast if the backup have all date a think only have to restat a server from 0 an put all files again but not sure for this help, is safe the backup from the pwAdmin??? they have all character items and data for mysql tables?
well i dont know what do thar fck noob i cant kill for any way the mysql i try some commands and all say fail, now i updating a new server whit the backup i hope works T_T
Thank to all responding