Also ich hab bei phpmyadmin über das interface alle gelöscht habe nur das root mit % gelassen so jetzt habe ich dort ein passwort gesetzt Porto.
So als ich den server neu starte ist Mysql deaktiviert und komme in phpmyadmin nicht mehr rein.
Server localhost
Fehler
MySQL meldet:
#1045 - Access denied for user: 'root@localhost' (Using password: NO)
So ich dachte das liekgt an der datei config.inc.php
$cfg['blowfish_secret'] = ''; // $cfg['blowfish_secret'] = 'password';
/**
* 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 ''.
$i++;
$cfg['Servers'][$i]['host'] = 'localhost'; // MySQL hostname or IP address
$cfg['Servers'][$i]['port'] = ''; // 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]['compress'] = FALSE; // Use compressed protocol for the MySQL connection
// (requires PHP >= 4.3.0)
$cfg['Servers'][$i]['controluser'] = 'root'; // MySQL control user settings
// (this user must have read-only
$cfg['Servers'][$i]['controlpass'] = ''; // access to the "mysql/user"
// and "mysql/db" tables)
$cfg['Servers'][$i]['auth_type'] = 'http'; // Authentication method (config, http or cookie based)?
$cfg['Servers'][$i]['user'] = 'root'; // MySQL user
$cfg['Servers'][$i]['password'] = 'porto'; // MySQL password (only needed
// with 'config' auth_type)
$cfg['Servers'][$i]['only_db'] = ''; // If set to a db-name, only
// this db is displayed
// at left frame
// It may also be an array
// of db-names
$cfg['Servers'][$i]['verbose'] = ''; // Verbose name for this host - leave blank to show the hostname
$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin'; // Database used for Relation, Bookmark and PDF Features
// (see scripts/create_tables.sql)
// - leave blank for no support
// DEFAULT: 'phpmyadmin'
$cfg['Servers'][$i]['bookmarktable'] = 'PMA_bookmark'; // Bookmark table
// - leave blank for no bookmark support
// DEFAULT: 'PMA_bookmark'
$cfg['Servers'][$i]['relation'] = 'PMA_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'] = 'PMA_table_info'; // table to describe the display fields
// - leave blank for no display fields support
// DEFAULT: 'PMA_table_info'
$cfg['Servers'][$i]['table_coords'] = 'PMA_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'] = 'PMA_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'] = 'PMA_column_info'; // table to store column information
// - leave blank for no column comments/mime types
// DEFAULT: 'PMA_column_info'
$cfg['Servers'][$i]['history'] = 'PMA_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]['AllowDeny']['order'] // Host authentication order, leave blank to not use
= '';
$cfg['Servers'][$i]['AllowDeny']['rules'] // Host authentication rules, leave blank for defaults
= array();
Habe dort den
$cfg['Servers'][$i]['controluser'] = 'pma';
auf
$cfg['Servers'][$i]['controluser'] = 'root'; gesetzt weil dachte es lag weil ich den POMa gelöscht habe ?
Aber nein server bleibt weiterhin down.
Achso habe noch auf http gestellt und das pass gleich wie bei phpmyadmin auf porto gestellt.
Warum deaktiviert er den SQl datenserver.
Danke für die hilfe schon im vorraus