My my.ini file:
- Code: Select all
# Example MySQL config file for medium systems.
#
# This is for a system with little memory (32M - 64M) where MySQL plays
# an important part, or systems up to 128M where MySQL is used together with
# other programs (such as a web server)
#
# You can copy this file to
# /etc/my.cnf to set global options,
# mysql-data-dir/my.cnf to set server-specific options (in this
# installation this directory is @localstatedir@) or
# ~/.my.cnf to set user-specific options.
#
# In this file, you can use all long options that a program supports.
# If you want to know which options a program supports, run the program
# with the "--help" option.
# The following options will be passed to all MySQL clients
[client]
#user = root
#password = secret
host = .
port = 3306
socket = "MySQL"
I get the following message when I try to connect the MySQL server:
- Code: Select all
mysql.exe -hlocalhost -uroot -psecret
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
- There is no ".../etc/" directory in my system. You couldn't mean ".../php/ext/" folder, could you...?
- I renamed "my.ini" file and copied it to ".../mysql/data/" folder as the commented section instructs. But still can not connect to the MySQL server.
- Do I have to change the line "host = .". I tried writing "127.0.0.1" instead of "." but nothing changed.
What am I doing wrong here?
I'm new to Xampp, any help will be appreciated.