Urgent help

[angelmx]

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

[MentaL]

[Zorno]

Hi some knows where is the folder phpmyadmin?? i have change the pass for php T_T some one enter to mi php and change the pass and now cant read the sql database please some tell me where is the file por change the pàss thanks

phpmyadmin is somewhere on your webserver. We cant know where you put it in.
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.

[angelmx]

phpmyadmin is somewhere on your webserver. We cant know where you put it in.
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/
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

[das7002]

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

mysql --no-defaults --bind-address=127.0.0.1 --bootstrap --console --skip-grant-tables --skip-innodb --standalone < resetroot.sql

Using

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);

As the resetroot.sql

[angelmx]

[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

mysql --no-defaults --bind-address=127.0.0.1 --bootstrap --console --skip-grant-tables --skip-innodb --standalone < resetroot.sql

No such file or directory.

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)

[das7002]

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

mysql --no-defaults --bind-address=127.0.0.1 --bootstrap --console --skip-grant-tables --skip-innodb --standalone < resetroot.sql

No such file or directory.

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...

[angelmx]

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: hrace009
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

[Zorno]

Why you use phpmyadmin anyway ?
I personally prefer Navicat. But ok, when you cannot access phpmyadmin maybe this helps you: Phpmyadmin password - PHWinfo

[angelmx]

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