Tijden veranderen
Verbinding SQL server
Access denied for user: '[email protected]' (Using password: YES)
Terwijl ik op de SQL server dezelfde username en password gebruik als in het config bestand.
Weet iemand wat ik hier aan moet doen? Alvast bedankt!!
Ik hoop dat je mij wilt helpen!
[mysqld]
basedir=C:/apache/mysql
#bind-address=192.168.0.2
datadir=C:/apache/mysql/data
#language=C:/apache/mysql/share/your language directory
#slow query log#=
#tmpdir#=
#port=3306
#set-variable=key_buffer=16M
[WinMySQLadmin]
Server=C:/apache/mysql/bin/mysqld-nt.exe
user=mmellema
password=mellema
En dit van het config bestand:
$cfgServers[1][\'host\'] = \'MELLEMA\'; // MySQL hostname
$cfgServers[1][\'port\'] = \'\'; // MySQL port - leave blank for default port
$cfgServers[1][\'socket\'] = \'\'; // Path to the socket - leave blank for default socket
$cfgServers[1][\'connect_type\'] = \'tcp\'; // How to connect to MySQL server (\'tcp\' or \'socket\')
$cfgServers[1][\'stduser\'] = \'\'; // MySQL standard user settings (this user must have read-only
$cfgServers[1][\'stdpass\'] = \'\'; // access to the \"mysql/user\" and \"mysql/db\" tables)
$cfgServers[1][\'auth_type\'] = \'config\'; // Authentication method (config, http or cookie based)?
$cfgServers[1][\'user\'] = \'mmellema\'; // MySQL user
$cfgServers[1][\'password\'] = \'mellema\'; // MySQL password (only needed with \'config\' auth)
$cfgServers[1][\'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
$cfgServers[1][\'verbose\'] = \'\'; // Verbose name for this host - leave blank to show the hostname
$cfgServers[1][\'bookmarkdb\'] = \'\'; // Bookmark db - leave blank for no bookmark support
$cfgServers[1][\'bookmarktable\'] = \'\'; // Bookmark table - leave blank for no bookmark support
$cfgServers[2][\'host\'] = \'MELLEMA\';
$cfgServers[2][\'port\'] = \'\';
$cfgServers[2][\'socket\'] = \'\';
$cfgServers[2][\'connect_type\'] = \'tcp\';
$cfgServers[2][\'stduser\'] = \'\';
$cfgServers[2][\'stdpass\'] = \'\';
$cfgServers[2][\'auth_type\'] = \'config\';
$cfgServers[2][\'user\'] = \'mmellema\';
$cfgServers[2][\'password\'] = \'mellema\';
$cfgServers[2][\'only_db\'] = \'\';
$cfgServers[2][\'verbose\'] = \'\';
$cfgServers[2][\'bookmarkdb\'] = \'\';
$cfgServers[2][\'bookmarktable\'] = \'\';
$cfgServers[3][\'host\'] = \'MELLEMA\';
$cfgServers[3][\'port\'] = \'\';
$cfgServers[3][\'socket\'] = \'\';
$cfgServers[3][\'connect_type\'] = \'tcp\';
$cfgServers[3][\'stduser\'] = \'\';
$cfgServers[3][\'stdpass\'] = \'\';
$cfgServers[3][\'auth_type\'] = \'config\';
$cfgServers[3][\'user\'] = \'mmellema\';
$cfgServers[3][\'password\'] = \'mellema\';
$cfgServers[3][\'only_db\'] = \'\';
$cfgServers[3][\'verbose\'] = \'\';
$cfgServers[3][\'bookmarkdb\'] = \'\';
$cfgServers[3][\'bookmarktable\'] = \'\';
Of de TS zelf misschien?
Elwin
op mysql.com (volgensmij) kan je in de documentatie lezen hoe je een wachtwoord kan ophalen
succes