i can start mysql in red hat, but when i use "mysqldump", the system say:"root@localhost is denied access"!why?who can tell me,please?
Hmmm this sounds like a job for: Manual man!
Mysql only accepts connections from users that have been added into mysql's access tables.
Read the manuals section about access rights and the GRANT statement.
first,thanks for your answer! i have setted privilege for root on localhost.The command is: "insert into user(user,host,db,....) values('root','localhost','%','y','y',...)" Have i setted wrong?Would you tell me the detail of setting?
Read the Mysql manual, use the GRANT statement.
thanks,let me try it!