Hello everyone, i'm not sure what to do here, here is the situation:
In phpmyadmin I changed the permissions for admin to everything except drop rather than everything.
now i cannot create new users, nor give them permissions.
So i tried running mysql_fix_privilege_tables.sql
my.cnf:HTML Code:mysql_fix_privilege_tables -uadmin -p***** -verbose This script updates all the mysql privilege tables to be usable by the current version of MySQL Got a failure from command: cat /usr/share/mysql/mysql_fix_privilege_tables.sql | /usr/bin/mysql --no-defaults --force --user=root --host=localhost --database=mysql Please check the above output and try again. Running the script with the --verbose option may give you some information of what went wrong. If you get an 'Access denied' error, you should run this script again and give the MySQL root user password as an argument with the --password= option
what can i do from hereHTML Code:[mysqld] set-variable=local-infile=0 datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql # Default to using old password format for compatibility with mysql 3.x # clients (those using the mysqlclient10 compatibility package). old_passwords=1 [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid?
Thanks for the help![]()



LinkBack URL
About LinkBacks
?
Reply With Quote





