Onforum.net - Web and gaming resource community

Register a free account today to become a member! Once signed in, you'll be able to participate on this site by adding your own topics and posts, as well as connect with other members .

Problema user in mysql.

Status
Not open for further replies.

[#Demonul]

Banned
Banned
Credits
0
Buna ziua!
Am luat serverfiles-ul ''BEST PRODUCTION V5'' pentru a incepe ''scoala'' pe el, dar din pacate nu pot reseta user-ul sau sa creez unul nou.
Am gasit multe rezolvari pe google, nu mi-a functionat nici-una, nu stiu ce sa-i fac...
Ma poate ajuta cineva, va rog?
Poza:
 

Attachments

  • Captură.JPG
    Captură.JPG
    60.1 KB · Views: 7
Salut, incearca sa rulezi urmatoarele comenzi mai intai.

Pentru inceput dai un reboot la vps;
Dupa care ruleaza urmatoarele comenzi:
  1. service mysql-server stop
  2. mysqld_safe --skip-grant-tables & (asteapta 5 secunde dupa rularea acestei comenzi)
  3. mysql -u root -p
  4. Introdu parola
  5. use mysql;
  6. CREATE USER 'Demonul'@'%' IDENTIFIED BY 'parolata';
  7. GRANT ALL PRIVILEGES ON * . * TO 'Demonul'@'%';
  8. flush privileges;
  9. exit;
Good luck ;)
 
Incearca sa-ti creezi un user direct din navicat, e mult mai simplu.
Te conectezi la baza de date al serverului, mergi la User si apesi pe butonul New User.
Completezi toate campurile libere, dai click pe Server Privileges, bifezi tot ce este acolo si salvezi.
 
Nu ma lasa. De-asta voiam sa schimb user-ul....

Incearca:

  1. service mysql-server restart
  2. service mysql-server stop
  3. mysql_upgrade -u root -p --verbose
  4. mysql -u root -p
  5. Introdu parola
  6. CREATE USER 'Demonul'@'%' IDENTIFIED BY 'parolata';
  7. GRANT ALL PRIVILEGES ON . TO 'Demonul'@'%' WITH GRANT OPTION;
  8. flush privileges;
  9. exit;
 
Last edited:
Status
Not open for further replies.
Thread starter Similar threads Forum Replies Date
Kvothe Solved threads 3

Similar threads


Top

Dear User!

We found that you are blocking the display of ads on our site.

Please add it to the exception list or disable AdBlock.

The advertises that you'll see aren't intrusive they just help us to keep the community alive

If you don't want to see those ads just buy an upgrade.

Thank you for understanding!

Rogue

Rogue Purchase

User upgrade! at

🔥 Upgrade Now
Baba2

Baba2 Purchase

User upgrade! at

🔥 Upgrade Now

Escanor25 Purchase

User upgrade! at

🔥 Upgrade Now