can,t add new user for mysql

chobo · 12-26-2007, 09:48 PM

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

ha ha ha

j-ray · 12-27-2007, 12:44 AM

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