Chris L. White said: > C:\MySQL\bin>mysql show > > ERROR 1045 (28000): Access denied for user: 'ODBC'@'localhost' (Using > password: > > YES) > > > > C:\MySQL\bin>mysql show -u root > > ERROR 1045 (28000): Access denied for user: 'root'@'localhost' (Using > password: > > YES) Your musql setup requires a password for root and you didn't include the -p so that mysql client will ask you for the password on the next line.
> > C:\MySQL\bin>mysql show -u root -p > > Enter password: ********** > > ERROR 1045 (28000): Access denied for user: 'root'@'localhost' (Using > password: > YES) > Did you enter the password which was configured or mysqld that you are runnning? > > > C:\MySQL\bin>mysql show -u administrator -p > > Enter password: ********** > > ERROR 1045 (28000): Access denied for user: 'administrator'@'localhost' > (Using p > > assword: YES) Administrator is windows OS equivalent to *nix 'root' but mysql expects its all powerful user to be called 'root' NOT administrator. > > C:\MySQL\bin> > Ah you are on widows.. on the right of the bottom bar (the one which can be hidden) is an icon which looks like a traffic signal(should have its green light on). Click on it and then click on 'Show Me' in the popup Go to the my.ini Setup tab and look for the root password. > Also here is my.ini file below: > > > > [mysqld] > > # set basedir to your installation path > > basedir=C:/mysql > > # set datadir to the location of your data directory > > datadir=C:/mysql/data > > > > # Example mysql config file. > > # Copy this file to c:\my.cnf to set global options > > # > > # One can use all long options that the program supports. > > # Run the program with --help to get a list of available options > > > > # This will be passed to all mysql clients > > [client] > > password=xxxxxx > > port=3306 > > socket=MySQL > > > > # Here is entries for some specific programs > > # The following values assume you have at least 32M ram > > > > # The MySQL server > > [mysqld] > > port=3306 > > socket=MySQL > > skip-locking > > set-variable = key_buffer=16M > > set-variable = max_allowed_packet=1M > > set-variable = table_cache=64 > > set-variable = sort_buffer=512K > > set-variable = net_buffer_length=8K > > set-variable = myisam_sort_buffer_size=8M > > server-id = 1 > > > > # Uncomment the following if you want to log updates > > log-bin > > > > # Uncomment the following rows if you move the MySQL distribution to > another > > # location > > # basedir = c:/mysql/ > > # datadir = c:/SQLData > > > > > > # Uncomment the following if you are NOT using BDB tables > > skip-bdb > > > > # Uncomment the following if you are using BDB tables > > #set-variable = bdb_cache_size=4M > > #set-variable = bdb_max_lock=10000 > > > > # Uncomment the following if you are using Innobase tables > > #innodb_data_file_path = ibdata1:400M > > #innodb_data_home_dir = c:\ibdata > > #innodb_log_group_home_dir = c:\iblogs > > #innodb_log_arch_dir = c:\iblogs > > #set-variable = innodb_mirrored_log_groups=1 > > #set-variable = innodb_log_files_in_group=3 > > #set-variable = innodb_log_file_size=5M > > #set-variable = innodb_log_buffer_size=8M > > #innodb_flush_log_at_trx_commit=1 > > #innodb_log_archive=0 > > #set-variable = innodb_buffer_pool_size=16M > > #set-variable = innodb_additional_mem_pool_size=2M > > #set-variable = innodb_file_io_threads=4 > > #set-variable = innodb_lock_wait_timeout=50 > > > > [mysqldump] > > quick > > set-variable = max_allowed_packet=16M > > > > [mysql] > > no-auto-rehash > > # Remove the next comment character if you are not familiar with SQL > > safe-updates > > > > [isamchk] > > set-variable = key_buffer=20M > > set-variable = sort_buffer=20M > > set-variable = read_buffer=2M > > set-variable = write_buffer=2M > > > > [myisamchk] > > set-variable = key_buffer=20M > > set-variable = sort_buffer=20M > > set-variable = read_buffer=2M > > set-variable = write_buffer=2M > > > > [mysqlhotcopy] > > interactive-timeout > > [WinMySQLAdmin] > > Server=C:/mysql/bin/mysqld-nt.exe > > user=administrator > > password=xxxxxxxx > > QueryInterval=5 > > Chris L. White > Network Administrator > Coe-Truman Technologies, Inc. > Email: [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
