configuration - Adding skip-grant-tables to MySQL my.ini does not seem to be working -


i trying reset lost root@localhost password, explained in this question.

adding line skip-grant-tables directly underneath [wampmysqld]/[mysqld] known way gain access in order reset passwords, in case not doing anything.

after making sure mysql not running, editing file, restarting , opening mysql console, password prompt appears, stuck.

what possibly overlooking?

my stack wamp 2.5, mysql 5.6.17.

my my.ini file looks this:

# example mysql config file medium systems. # # system little memory (32m - 64m) mysql plays # important part, or systems 128m mysql used # other programs (such web server) # # can copy file # /etc/my.cnf set global options, # mysql-data-dir/my.cnf set server-specific options (in # installation directory c:\mysql\data) or # ~/.my.cnf set user-specific options. # # in file, can use long options program supports. # if want know options program supports, run program # "--help" option.  # following options passed mysql clients [client] #password   = your_password port        = 3306 socket      = /tmp/mysql.sock  # here follows entries specific programs  # mysql server [wampmysqld] skip-grant-tables port        = 3306 socket      = /tmp/mysql.sock key_buffer_size = 16m max_allowed_packet = 1m sort_buffer_size = 512k net_buffer_length = 8k read_buffer_size = 256k read_rnd_buffer_size = 512k myisam_sort_buffer_size = 8m basedir=c:/wamp/bin/mysql/mysql5.6.17 log-error=c:/wamp/logs/mysql.log datadir=c:/wamp/bin/mysql/mysql5.6.17/data  lc-messages-dir=c:/wamp/bin/mysql/mysql5.6.17/share  # change locale here ! lc-messages=fr_fr  # avoid warning explicit_defaults_for_timestamp = true  # don't listen on tcp/ip port @ all. can security enhancement, # if processes need connect mysqld run on same host. # interaction mysqld must made via unix sockets or named pipes. # note using option without enabling named pipes on windows # (via "enable-named-pipe" option) render mysqld useless! #  #skip-networking  # disable federated default skip-federated  # replication master server (default) # binary logging required replication log-bin=mysql-bin  # binary logging format - mixed recommended binlog_format=mixed  # required unique id between 1 , 2^32 - 1 # defaults 1 if master-host not set # not function master if omitted server-id   = 1  # replication slave (comment out master section use this)   # new mysql 5.6 if no slave # skip-slave-start  # # configure host replication slave, can choose between # 2 methods : # # 1) use change master command (fully described in our manual) - #    syntax is: # #    change master master_host=<host>, master_port=<port>, #    master_user=<user>, master_password=<password> ; # #    replace <host>, <user>, <password> quoted strings , #    <port> master's port number (3306 default). # #    example: # #    change master master_host='125.564.12.1', master_port=3306, #    master_user='joe', master_password='secret'; # # or # # 2) set variables below. however, in case choose method, #    start replication first time (even unsuccessfully, example #    if mistyped password in master-password , slave fails #    connect), slave create master.info file, , later #    change in file variables' values below ignored , #    overridden content of master.info file, unless shutdown #    slave server, delete master.info , restart slaver server. #    reason, may want leave lines below untouched #    (commented) , instead use change master (see above) # # required unique id between 2 , 2^32 - 1 # (and different master) # defaults 2 if master-host set # not function slave if omitted #server-id       = 2 # # replication master slave - required #master-host     =   <hostname> # # username slave use authentication when connecting # master - required #master-user     =   <username> # # password slave authenticate when connecting # master - required #master-password =   <password> # # port master listening on. # optional - defaults 3306 #master-port     =  <port> # # binary logging - not required slaves, recommended #log-bin=mysql-bin  # point following paths different dedicated disks #tmpdir     = /tmp/      #log-update     = /path-to-dedicated-directory/hostname  # uncomment following if using innodb tables #innodb_data_home_dir = c:\mysql\data/ #innodb_data_file_path = ibdata1:10m:autoextend #innodb_log_group_home_dir = c:\mysql\data/ #innodb_log_arch_dir = c:\mysql\data/ # can set .._buffer_pool_size 50 - 80 % # of ram beware of setting memory usage high #innodb_buffer_pool_size = 16m #innodb_additional_mem_pool_size = 2m # set .._log_file_size 25 % of buffer pool size #innodb_log_file_size = 5m #innodb_log_buffer_size = 8m #innodb_flush_log_at_trx_commit = 1 #innodb_lock_wait_timeout = 50  [mysqldump] quick max_allowed_packet = 16m  [mysql] no-auto-rehash # remove next comment character if not familiar sql #safe-updates  [isamchk] key_buffer = 20m sort_buffer_size = 20m read_buffer = 2m write_buffer = 2m  [myisamchk] key_buffer = 20m sort_buffer_size = 20m read_buffer = 2m write_buffer = 2m  [mysqlhotcopy] interactive-timeout  [mysqld] port=3306 explicit_defaults_for_timestamp = true 

you can start server skip-grant-tables command line:

 mysqld_safe --skip-grant-tables & 

Comments

Popular posts from this blog

node.js - Mongoose: Cast to ObjectId failed for value on newly created object after setting the value -

gradle error "Cannot convert the provided notation to a File or URI" -

python - NameError: name 'subprocess' is not defined -