Welcome to the most active Linux Forum on the web.
Go Back > Forums > Linux Forums > Linux - Newbie
User Name
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!


  Search this Thread
Old 12-26-2007, 09:48 PM   #1
LQ Newbie
Registered: Nov 2007
Posts: 21

Rep: Reputation: 15
Question can,t add new user for mysql

my new case


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

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 )


o ya special thanks for chrism01

ha ha ha
Old 12-27-2007, 12:44 AM   #2
Senior Member
Registered: Jan 2002
Location: germany
Distribution: ubuntu, mint, suse
Posts: 1,591

Rep: Reputation: 145Reputation: 145
mkdir /tmp/mysql
chmod 0777 /tmp/mysql

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

restart mysqld as root


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
How to add mysqld_safe --user=mysql & in /etc/rc.d/rc.local Han_Nguyen Mandriva 11 07-16-2007 06:40 PM
MySQL add user tommytomato Linux - Newbie 1 02-19-2004 10:24 AM
MySQL db exists, can't connect to it, do I need to add user to it? Hero Doug Linux - General 7 01-09-2004 03:54 PM
Cant add MySQL through add/remove programs Hero Doug Fedora 6 01-03-2004 10:35 PM
How do I add a host user password to mysql server? cmisip Linux - Networking 3 12-16-2002 09:57 AM > Forums > Linux Forums > Linux - Newbie

All times are GMT -5. The time now is 01:36 AM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration