can,t add new user for mysql
 

my new case

Error

SQL query:

SHOW COLUMNS FROM `mysql`.`user` ;

MySQL said: Documentation
#1 - Can't create/write to file '/tmp/#sql_fbf_0.MYI' (Errcode: 13)

its accured after i trying to fix it of

User 'u5'@'localhost' - Database drupaltestdb : Edit Privileges
Error

SQL query:

SHOW COLUMNS FROM `mysql`.`db` ;

MySQL said: Documentation
#1 - Can't create/write to file '/tmp/#sql_7a8_0.MYI' (Errcode: 13)

i still have mysql's problem .that accured above ( state one )


thanks

o ya special thanks for chrism01

:confused: ha ha ha

mkdir /tmp/mysql
chmod 0777 /tmp/mysql

edit my.cnf (this may reside in /etc or where you installed mysql)
set
tmpdir=/tmp/mysql

restart mysqld as root