LinuxQuestions.org
Help answer threads with 0 replies.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
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!

Notices


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

Rep: Reputation: 15
Question 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

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

Rep: Reputation: 136Reputation: 136
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
 
  


Reply


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

LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie

All times are GMT -5. The time now is 10:30 AM.

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