Guest User

mysqli_real_connect(): (HY000/2006): MySQL server has gone a

a guest
Aug 27th, 2018
179
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 6.32 KB | None | 0 0
  1. I am having an issue with logging into phpMyAdmin.
  2.  
  3. I have simply install xampp. when i launch the Xampp server it show me port error for 3306 so i have change the port from 3306 to 3307 in my.ini file and config -> Service and Port Settings -> Mysql port Tab
  4.  
  5. Service Setting of Xampp Control Panel
  6.  
  7. Then i was able to start SQL server
  8.  
  9. when i try to open PhpMyadmin it show me error like this than i change in config.inc.php
  10.  
  11. config.inc.php
  12.  
  13. Now when i try to open PhpMyadmin it ask me for username and password
  14.  
  15. Username - root
  16. Password - Null
  17. it show me error like this Error while login in PhpMyadmin
  18.  
  19. my.ini File without editing
  20. # Example MySQL config file for small systems.
  21. #
  22. # This is for a system with little memory (<= 64M) where MySQL is only used
  23. # from time to time and it's important that the mysqld daemon
  24. # doesn't use much resources.
  25. #
  26. # You can copy this file to
  27. # C:/xampp/mysql/bin/my.cnf to set global options,
  28. # mysql-data-dir/my.cnf to set server-specific options (in this
  29. # installation this directory is C:/xampp/mysql/data) or
  30. # ~/.my.cnf to set user-specific options.
  31. #
  32. # In this file, you can use all long options that a program supports.
  33. # If you want to know which options a program supports, run the program
  34. # with the "--help" option.
  35.  
  36. # The following options will be passed to all MySQL clients
  37. [client]
  38. # password = your_password
  39. port = 3306
  40. socket = "C:/xampp/mysql/mysql.sock"
  41.  
  42.  
  43. # Here follows entries for some specific programs
  44.  
  45. # The MySQL server
  46. [mysqld]
  47. port= 3306
  48. socket = "C:/xampp/mysql/mysql.sock"
  49. basedir = "C:/xampp/mysql"
  50. tmpdir = "C:/xampp/tmp"
  51. datadir = "C:/xampp/mysql/data"
  52. pid_file = "mysql.pid"
  53. # enable-named-pipe
  54. key_buffer = 16M
  55. max_allowed_packet = 1M
  56. sort_buffer_size = 512K
  57. net_buffer_length = 8K
  58. read_buffer_size = 256K
  59. read_rnd_buffer_size = 512K
  60. myisam_sort_buffer_size = 8M
  61. log_error = "mysql_error.log"
  62.  
  63. # Change here for bind listening
  64. # bind-address="127.0.0.1"
  65. # bind-address = ::1 # for ipv6
  66.  
  67. # Where do all the plugins live
  68. plugin_dir = "C:/xampp/mysql/lib/plugin/"
  69.  
  70. # Don't listen on a TCP/IP port at all. This can be a security enhancement,
  71. # if all processes that need to connect to mysqld run on the same host.
  72. # All interaction with mysqld must be made via Unix sockets or named pipes.
  73. # Note that using this option without enabling named pipes on Windows
  74. # (via the "enable-named-pipe" option) will render mysqld useless!
  75. #
  76. # commented in by lampp security
  77. #skip-networking
  78. #skip-federated
  79.  
  80. # Replication Master Server (default)
  81. # binary logging is required for replication
  82. # log-bin deactivated by default since XAMPP 1.4.11
  83. #log-bin=mysql-bin
  84.  
  85. # required unique id between 1 and 2^32 - 1
  86. # defaults to 1 if master-host is not set
  87. # but will not function as a master if omitted
  88. server-id = 1
  89.  
  90. # Replication Slave (comment out master section to use this)
  91. #
  92. # To configure this host as a replication slave, you can choose between
  93. # two methods :
  94. #
  95. # 1) Use the CHANGE MASTER TO command (fully described in our manual) -
  96. # the syntax is:
  97. #
  98. # CHANGE MASTER TO MASTER_HOST=<host>, MASTER_PORT=<port>,
  99. # MASTER_USER=<user>, MASTER_PASSWORD=<password> ;
  100. #
  101. # where you replace <host>, <user>, <password> by quoted strings and
  102. # <port> by the master's port number (3306 by default).
  103. #
  104. # Example:
  105. #
  106. # CHANGE MASTER TO MASTER_HOST='125.564.12.1', MASTER_PORT=3306,
  107. # MASTER_USER='joe', MASTER_PASSWORD='secret';
  108. #
  109. # OR
  110. #
  111. # 2) Set the variables below. However, in case you choose this method, then
  112. # start replication for the first time (even unsuccessfully, for example
  113. # if you mistyped the password in master-password and the slave fails to
  114. # connect), the slave will create a master.info file, and any later
  115. # change in this file to the variables' values below will be ignored and
  116. # overridden by the content of the master.info file, unless you shutdown
  117. # the slave server, delete master.info and restart the slaver server.
  118. # For that reason, you may want to leave the lines below untouched
  119. # (commented) and instead use CHANGE MASTER TO (see above)
  120. #
  121. # required unique id between 2 and 2^32 - 1
  122. # (and different from the master)
  123. # defaults to 2 if master-host is set
  124. # but will not function as a slave if omitted
  125. #server-id = 2
  126. #
  127. # The replication master for this slave - required
  128. #master-host = <hostname>
  129. #
  130. # The username the slave will use for authentication when connecting
  131. # to the master - required
  132. #master-user = <username>
  133. #
  134. # The password the slave will authenticate with when connecting to
  135. # the master - required
  136. #master-password = <password>
  137. #
  138. # The port the master is listening on.
  139. # optional - defaults to 3306
  140. #master-port = <port>
  141. #
  142. # binary logging - not required for slaves, but recommended
  143. #log-bin=mysql-bin
  144.  
  145.  
  146. # Point the following paths to different dedicated disks
  147. #tmpdir = "C:/xampp/tmp"
  148. #log-update = /path-to-dedicated-directory/hostname
  149.  
  150. # Uncomment the following if you are using BDB tables
  151. #bdb_cache_size = 4M
  152. #bdb_max_lock = 10000
  153.  
  154. # Comment the following if you are using InnoDB tables
  155. #skip-innodb
  156. innodb_data_home_dir = "C:/xampp/mysql/data"
  157. innodb_data_file_path = ibdata1:10M:autoextend
  158. innodb_log_group_home_dir = "C:/xampp/mysql/data"
  159. #innodb_log_arch_dir = "C:/xampp/mysql/data"
  160. ## You can set .._buffer_pool_size up to 50 - 80 %
  161. ## of RAM but beware of setting memory usage too high
  162. innodb_buffer_pool_size = 16M
  163. innodb_additional_mem_pool_size = 2M
  164. ## Set .._log_file_size to 25 % of buffer pool size
  165. innodb_log_file_size = 5M
  166. innodb_log_buffer_size = 8M
  167. innodb_flush_log_at_trx_commit = 1
  168. innodb_lock_wait_timeout = 50
  169.  
  170. ## UTF 8 Settings
  171. #init-connect=\'SET NAMES utf8\'
  172. #collation_server=utf8_unicode_ci
  173. #character_set_server=utf8
  174. #skip-character-set-client-handshake
  175. #character_sets-dir="C:/xampp/mysql/share/charsets"
  176.  
  177. [mysqldump]
  178. quick
  179. max_allowed_packet = 16M
  180.  
  181. [mysql]
  182. no-auto-rehash
  183. # Remove the next comment character if you are not familiar with SQL
  184. #safe-updates
  185.  
  186. [isamchk]
  187. key_buffer = 20M
  188. sort_buffer_size = 20M
  189. read_buffer = 2M
  190. write_buffer = 2M
  191.  
  192. [myisamchk]
  193. key_buffer = 20M
  194. sort_buffer_size = 20M
  195. read_buffer = 2M
  196. write_buffer = 2M
  197.  
  198. [mysqlhotcopy]
  199. interactive-timeout
  200.  
  201.  
  202. Please Help me to find an issue
  203.  
  204. Thanks in advance
Add Comment
Please, Sign In to add comment