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
Post a Comment