Quote:
Originally Posted by IgorGlock
^ auch eine Möglichkeit.
Nur dumm, wenn er's tun würde.
Lösung:
Code:
/usr/local/etc/rc.d/mysql-server stop
/usr/local/bin/mysql_install_db
/usr/local/bin/mysqld_safe –user=mysql &
/usr/local/bin/mysqladmin -u root password newpassword
mysql -p
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'
IDENTIFIED BY 'newpassword' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO 'mt2'@'localhost'
IDENTIFIED BY 'mt2!@#' WITH GRANT OPTION;
quit
reboot
newpassword ist nun dein neues "root" PW. |
Fehler Codes :
j049# /usr/local/etc/rc.d/mysql-server stop
Stopping mysql.
Waiting for PIDS: 18306.
j049# /usr/local/bin/mysql_install_db
FATAL ERROR: Could not find ./bin/my_print_defaults
If you compiled from source, you need to run 'make install' to
copy the software into the correct location ready for operation.
If you are using a binary release, you must either be at the top
level of the extracted archive, or pass the --basedir option
pointing to that location.
j049# /usr/local/bin/mysqld_safe .user=mysql &
[1] 18329
j049# 101105 12:24:44 mysqld_safe Logging to '/var/db/mysql/j049.err'.
101105 12:24:44 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
101105 12:24:45 mysqld_safe mysqld from pid file /var/db/mysql/j049.pid ended
[1] Done /usr/local/bin/mysqld_safe .user=mysql
j049# /usr/local/bin/mysqladmin -u root password newpassword
/usr/local/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!
j049# mysql -p
Enter password:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
j049# GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'
GRANT: No match.
j049# IDENTIFIED BY 'newpassword' WITH GRANT OPTION;
IDENTIFIED: Command not found.
j049# GRANT ALL PRIVILEGES ON *.* TO 'mt2'@'localhost'
GRANT: No match.
j049# IDENTIFIED BY 'mt2!@#' WITH GRANT OPTION;
@: Event not found.
j049# quit
quit: Command not found.
j049#
MySQL
gemacht aber immer wenn ich zu MySQL mit Navicat connecten will kommt dieser Fehler : 1130 - Host 'p5B07AD2B.dop.t.dialin.net' is not allowed to connect to this MySQL server
