Temat: MySQL - nie mogę się podłączy
Zainstalowałem PhpMyAdmin na moim routerze, strona się ładuje ale na podanie login/passwd wyskakuje komunikat
Nie udało się zalogować na serwer MySQLale do samej bazy podłączyć się mogę poprzez polecenie
mysql -u root -pWycinek php.ini
[MySQL]
mysql.allow_local_infile = On
mysql.allow_persistent = On
mysql.cache_size = 2000
mysql.max_persistent = -1
mysql.max_links = -1
mysql.default_port = 3306 <--Dodałem, ale bez zmiany
mysql.default_socket =
mysql.default_host =
mysql.default_user =
mysql.default_password =
mysql.connect_timeout = 60
mysql.trace_mode = Offroot@OpenWrt:/# cat /etc/my.cnf
[client]
port = 3306
socket = /var/run/mysqld.sock
[mysqld]
user = root
socket = /var/run/mysqld.sock
port = 3306
basedir = /usr
############ Don't put this on the NAND #############
# Figure out where you are going to put the databases
# And run mysql_install_db --force
datadir = /mnt/sdb1/mysql/
######### This should also not go on the NAND #######
tmpdir = /mnt/sdb1/tmp
skip-external-locking
bind-address = 127.0.0.1
# Fine Tuning
key_buffer = 2M
max_allowed_packet = 2M
thread_stack = 192K
thread_cache_size = 8
# Here you can see queries with especially long duration
log_slow_queries = /var/log/mysql/mysql-slow.log
#long_query_time = 2
#log-queries-not-using-indexes
# The following can be used as easy to replay backup logs or for replication.
#server-id = 1
#log_bin = /var/log/mysql/mysql-bin.log
#expire_logs_days = 10
#max_binlog_size = 100M
#binlog_do_db = include_database_name
#binlog_ignore_db = include_database_name
[mysqldump]
quick
quote-names
max_allowed_packet = 2M
[mysql]
#no-auto-rehash # faster start of mysql but no tab completition
[isamchk]
key_buffer = 2M