我更改了phpmyadmin mysql端口号,现在我无法登录
发布时间:2020-12-13 16:10:49 所属栏目:PHP教程 来源:网络整理
导读:我有一个在端口3307本地运行的 mysql服务器,我可以通过命令行连接到正常 mysql -P 3307 -h 127.0.0.1 -u root -p 为了通过phpmyadmin访问这个数据库,我在/etc/phpMyAdmin/config.inc.php中更改了这些设置 $cfg['Servers'][$i]['host'] = '127.0.0.1';$cfg['S
我有一个在端口3307本地运行的
mysql服务器,我可以通过命令行连接到正常
mysql -P 3307 -h 127.0.0.1 -u root -p 为了通过phpmyadmin访问这个数据库,我在/etc/phpMyAdmin/config.inc.php中更改了这些设置 $cfg['Servers'][$i]['host'] = '127.0.0.1'; $cfg['Servers'][$i]['port'] = '3307'; 但是,当我尝试登录时,我收到一条错误消息“无法登录到mysql服务器”.这可能是apache阻止登录的问题吗? 我尝试使用localhost / phpMyAdmin和127.0.0.1/phpMyAdmin进行连接. 下面是我的config.inc.php文件 <?php /** * phpMyAdmin configuration file,you can use it as base for the manual * configuration. For easier setup you can use "setup/". * * All directives are explained in Documentation.html and on phpMyAdmin * wiki <http://wiki.phpmyadmin.net>. */ /* * This is needed for cookie based authentication to encrypt password in * cookie */ $cfg['blowfish_secret'] = 'QbDRiRCsQqyy6Bo19EkakjW23Ua8uJYo'; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */ /** * Server(s) configuration */ $i = 0; // The $cfg['Servers'] array starts with $cfg['Servers'][1]. Do not use // $cfg['Servers'][0]. You can disable a server config entry by setting host // to ''. If you want more than one server,just copy following section // (including $i incrementation) serveral times. There is no need to define // full server array,just define values you need to change. $i++; $cfg['Servers'][$i]['host'] = '127.0.0.1'; // MySQL hostname or IP address $cfg['Servers'][$i]['port'] = '3307'; // MySQL port - leave blank for default port $cfg['Servers'][$i]['socket'] = ''; // Path to the socket - leave blank for default socket $cfg['Servers'][$i]['connect_type'] = 'tcp'; // How to connect to MySQL server ('tcp' or 'socket') $cfg['Servers'][$i]['extension'] = 'mysqli'; // The php MySQL extension to use ('mysql' or 'mysqli') $cfg['Servers'][$i]['compress'] = FALSE; // Use compressed protocol for the MySQL connection // (requires PHP >= 4.3.0) $cfg['Servers'][$i]['controluser'] = ''; // MySQL control user settings // (this user must have read-only $cfg['Servers'][$i]['controlpass'] = ''; // access to the "mysql/user" // and "mysql/db" tables). // The controluser is also // used for all relational // features (pmadb) $cfg['Servers'][$i]['auth_type'] = 'cookie'; // Authentication method (config,http or cookie based)? $cfg['Servers'][$i]['user'] = ''; // MySQL user $cfg['Servers'][$i]['password'] = ''; // MySQL password (only needed // with 'config' auth_type) $cfg['Servers'][$i]['only_db'] = ''; // If set to a db-name,only // this db is displayed in left frame // It may also be an array of db-names,where sorting order is relevant. $cfg['Servers'][$i]['hide_db'] = ''; // Database name to be hidden from listings $cfg['Servers'][$i]['verbose'] = ''; // Verbose name for this host - leave blank to show the hostname $cfg['Servers'][$i]['pmadb'] = ''; // Database used for Relation,Bookmark and PDF Features // (see scripts/create_tables.sql) // - leave blank for no support // DEFAULT: 'phpmyadmin' $cfg['Servers'][$i]['bookmarktable'] = ''; // Bookmark table // - leave blank for no bookmark support // DEFAULT: 'pma_bookmark' $cfg['Servers'][$i]['relation'] = ''; // table to describe the relation between links (see doc) // - leave blank for no relation-links support // DEFAULT: 'pma_relation' $cfg['Servers'][$i]['table_info'] = ''; // table to describe the display fields // - leave blank for no display fields support // DEFAULT: 'pma_table_info' $cfg['Servers'][$i]['table_coords'] = ''; // table to describe the tables position for the PDF schema // - leave blank for no PDF schema support // DEFAULT: 'pma_table_coords' $cfg['Servers'][$i]['pdf_pages'] = ''; // table to describe pages of relationpdf // - leave blank if you don't want to use this // DEFAULT: 'pma_pdf_pages' $cfg['Servers'][$i]['column_info'] = ''; // table to store column information // - leave blank for no column comments/mime types // DEFAULT: 'pma_column_info' $cfg['Servers'][$i]['history'] = ''; // table to store SQL history // - leave blank for no SQL query history // DEFAULT: 'pma_history' $cfg['Servers'][$i]['verbose_check'] = TRUE; // set to FALSE if you know that your pma_* tables // are up to date. This prevents compatibility // checks and thereby increases performance. $cfg['Servers'][$i]['AllowRoot'] = TRUE; // whether to allow root login $cfg['Servers'][$i]['AllowDeny']['order'] // Host authentication order,leave blank to not use = ''; $cfg['Servers'][$i]['AllowDeny']['rules'] // Host authentication rules,leave blank for defaults = array(); $cfg['Servers'][$i]['AllowNoPassword'] // Allow logins without a password. Do not change the FALSE = TRUE; // default unless you're running a passwordless MySQL server $cfg['Servers'][$i]['designer_coords'] // Leave blank (default) for no Designer support,otherwise = ''; // set to suggested 'pma_designer_coords' if really needed $cfg['Servers'][$i]['bs_garbage_threshold'] // Blobstreaming: Recommented default value from upstream = 50; // DEFAULT: '50' $cfg['Servers'][$i]['bs_repository_threshold'] // Blobstreaming: Recommented default value from upstream = '32M'; // DEFAULT: '32M' $cfg['Servers'][$i]['bs_temp_blob_timeout'] // Blobstreaming: Recommented default value from upstream = 600; // DEFAULT: '600' $cfg['Servers'][$i]['bs_temp_log_threshold'] // Blobstreaming: Recommented default value from upstream = '32M'; // DEFAULT: '32M' /* * End of servers configuration */ /* * Directories for saving/loading files from server */ $cfg['UploadDir'] = '/var/lib/phpMyAdmin/upload'; $cfg['SaveDir'] = '/var/lib/phpMyAdmin/save'; /* * Disable the default warning that is displayed on the DB Details Structure * page if any of the required Tables for the relation features is not found */ $cfg['PmaNoRelation_DisableWarning'] = TRUE; /* * phpMyAdmin 4.4.x is no longer maintained by upstream,but security fixes * are still backported by downstream. */ $cfg['VersionCheck'] = FALSE; ?> 解决方法
转到xampp> phpMyAdmin目录.
找到config.inc.php文件. 现在改变这一行: $cfg['Servers'][$i]['host'] = '127.0.0.1'; 至 $cfg['Servers'][$i]['host'] = '127.0.0.1:3307'; 要么 打开位于XAMPP / mysql / bin /目录中的my.ini文件,找到包含数字3306,eq:port = 3306的单词,然后将其替换为您自己的文件,例如3307. (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |