mysql - No Privileges error with phpMyAdmin when I click Users -



mysql - No Privileges error with phpMyAdmin when I click Users -

i tried set root password phpmyadmin , phpmyadmin->users shows error "no privileges"

background

just installed mysql (with xampp) - , tried alter "root" password via phpmyadmin->users->root->password.

now phpmyadmin->users shows error "no privileges"

how things back, , remove error.

also - maybe nothing, when first tried alter password, pressed "wong" go button, 1 @ end, , created "root" user. deleted user.

my config.inc.php file has:

$cfg['servers'][$i]['user'] = 'root'; $cfg['servers'][$i]['password'] = '';

if logged in root user , changed root user password, need tell phpmyadmin new password, otherwise won't logged in , "no privileges" errors :-)

with phpmyadmin, there several authentication methods ("auth_types") can used. they're configured in configuration file, config.inc.php, line $cfg['servers'][$i]['auth_type'] = 'cookie';. possible choices "config" username , password hard coded in configuration file, , "cookie" or "http" user prompted username , password on login. don't know how xampp it, since have $cfg['servers'][$i]['user'] = 'root'; , $cfg['servers'][$i]['password'] = ''; lines auth_type config (those lines meaningless other types).

so in case, plug new password in password field instead of having blank posted above.

it's possible deleted wrong root user. there @ to the lowest degree 2 on mysql installation different host fields; they're used in different connection scenarios (whether you're connecting via socket or tcp connection, instance, or machine on network). if happen have deleted wrong one, may have refer mysql manual instructions reset lost password , recreate user you're missing.

mysql phpmyadmin xampp

Comments

Post a Comment

Popular posts from this blog

model view controller - MVC Rails Planning -

model view controller - MVC Rails Planning - i'm starting rails , i'm building app stores films info, user can watch film , give grade on web application. i have coded cinema model, controller , views. now, have 2 questions: should need create model , controller grading? in case, should create or should wait , create first users model , controller? yes, on model , controller grades. that'd feasible way maintain track of who's graded what. it's create first, i'd start users, since grades depend on both films , users. ruby-on-rails model-view-controller
Read more

ruby on rails - Devise Logout Error in RoR -

ruby on rails - Devise Logout Error in RoR - while using devise in ror, encountering unusual error when trying log out url different root url. displays me : actioncontroller::invalidauthenticitytoken in devise::sessionscontroller#destroy" for illustration if rooting path after log in '/structure', , seek log out '/general' error, while logging out '/structure' fine. any help highly appreciated. ruby-on-rails ruby devise
Read more

html - Submenu setup with jquery and effect 'fold' -

html - Submenu setup with jquery and effect 'fold' - i want open submenu jquery effect fold, problem if user "hover effect" fast menu remain open, how can avoid this, jquery code is: $('ul.mainmenu li').hover( function() { $(this).children('ul').show('fold', 570); }, function() { $(this).children('ul').hide('fold', 500); } ); my jsfiddle link is: http://jsfiddle.net/9wkbf/ updated fiddle the reason behind problem is, first event $(this).children('ul').show('fold', 570); queued , until completes, sec animation not start. the next snippet can workaround $('ul.mainmenu > li').hover( function() { $(this).children('ul').show('fold', 570); }, function() { $('ul:not(.mainmenu)').hide('fold', 500); } ); *important note : work current scenario. jquery html css
Read more