create database outside /mysql/data/
I installed Mysql on windows and found out that the documentation does not talk about installing the database in another directory or partition of the disk. Is it possible in Windows? I have little space left on the partition where progrxxxFiles/mysql/ is. THanks Laurie -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: telnet localhost 3306 Connection refused
Have you checked that the user failing to connect has the right privileges? Check the user table of mysql database to see if that user has a select privilege in that table. Laurie At 01:01 AM 7/7/2005, Daevid Vincent wrote: What is causing me to have this problem in mysql Ver 12.22 Distrib 4.0.24, for pc-linux-gnu (i686). I am running shorewall, but that shouldn't affect localhost should it? My firewall, web, and mySQL server are the same machine. # telnet localhost 3306 Trying 127.0.0.1... telnet: Unable to connect to remote host: Connection refused I've tried to comment, uncomment and change to * this 'bind-address' line in /etc/mysql/my.cnf # keep secure by default! #bind-address= 127.0.0.1 #bind-address= * port= 3306 Of course, I can't connect from any of the other IP addresses that my mySQL server is assigned either: # telnet 192.168.1.1 3306 Trying 192.168.1.1... telnet: Unable to connect to remote host: Connection refused # telnet 10.10.10.1 3306 Trying 10.10.10.1... telnet: Unable to connect to remote host: Connection refused # ifconfig eth1 Link encap:Ethernet inet addr:192.168.1.1 Bcast:192.168.1.255 Mask:255.255.255.0 loLink encap:Local Loopback inet addr:127.0.0.1 Mask:255.0.0.0 wlan0 Link encap:Ethernet inet addr:10.10.10.1 Bcast:10.255.255.255 Mask:255.255.255.0 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
GRANT and mysql.user table
I tried as root having GRANT ALL PRIVILEGES with GRANT OPTION to change the privilege of a user: GRANT ALL ON mydb.* TO myUser; The result of this statement is that the query is OK and 0 rows are affected. WHen I look at the mysql table holding the grants: user, the myUser row is unchanged. What could possibly be preventing the system from changing the GRANT of myUser? Is the mysql.db table part of the granting? thanks in advance for your help. laurie -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
import data into table with existing data fails
I imported data into a table mytable into a databse mydb with existing data. mysqlimport -L mydb data.txt that operation failed. I interrupt it. It seems that I imported data with the same indexes (duplicate entries) I tried: delete from mytable; that seems to fail too What happens when you interrupt such operation: unstable state (indexes, references to other keys ...) What can I do to repair? Should I drop the table, create it again and fill it up with my data? Or is there more to do than that? Thank you for your suggestions Laurie -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
WARNING!!!! abuser on this list?
When I opened the message send by: [EMAIL PROTECTED] subject: Boolean searches a pop up box appeared stating Connect to 70.84.29.164 Web host manager Username mymachine/administrator password: Has anybody encountered this problem when you cliked on his email Should we FLAME that guy? In the mean time I am sending an email to [EMAIL PROTECTED] owning that IP address. Here is the headers of his email: Received: (qmail 7362 invoked by uid 109); 8 Apr 2005 17:13:25 - Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm List-ID: mysql.mysql.com Precedence: bulk List-Help: mailto:[EMAIL PROTECTED] List-Unsubscribe: mailto:[EMAIL PROTECTED] List-Post: mailto:mysql@lists.mysql.com List-Archive: http://lists.mysql.com/mysql/182353 Delivered-To: mailing list mysql@lists.mysql.com Received: (qmail 7312 invoked from network); 8 Apr 2005 17:13:24 - Received-SPF: pass (lists.mysql.com: local policy) Reply-To: [EMAIL PROTECTED] From: [EMAIL PROTECTED] To: Mysql mysql@lists.mysql.com Subject: Boolean searches Date: Fri, 8 Apr 2005 11:13:13 -0600 Message-ID: [EMAIL PROTECTED] MIME-Version: 1.0 Content-Type: multipart/related; boundary==_NextPart_000_0098_01C53C2B.F4751020 X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.6604 (9.0.2911.0) Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2527 X-PopBeforeSMTPSenders: [EMAIL PROTECTED],[EMAIL PROTECTED],[EMAIL PROTECTED],[EMAIL PROTECTED],[EMAIL PROTECTED],[EMAIL PROTECTED],[EMAIL PROTECTED],gunmuse,[EMAIL PROTECTED],[EMAIL PROTECTED],[EMAIL PROTECTED],[EMAIL PROTECTED],[EMAIL PROTECTED],[EMAIL PROTECTED],[EMAIL PROTECTED],[EMAIL PROTECTED],[EMAIL PROTECTED],[EMAIL PROTECTED],redmoon,[EMAIL PROTECTED],[EMAIL PROTECTED],[EMAIL PROTECTED] X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - pistol.gunmuse.us X-AntiAbuse: Original Domain - lists.mysql.com X-AntiAbuse: Originator/Caller UID/GID - [0 0] / [47 12] X-AntiAbuse: Sender Address Domain - gunmuse.com X-Source: X-Source-Args: X-Source-Dir: X-Virus-Checked: Checked X-Spam-Checker-Version: SpamAssassin 3.0.2 (2004-11-16) on c.spam X-Spam-Status: No, score=1.1 required=5.0 tests=DNS_FROM_AHBL_RHSBL, HTML_MESSAGE,HTML_TAG_EXIST_TBODY,NORMAL_HTTP_TO_IP,NO_REAL_NAME, WEIRD_PORT autolearn=disabled version=3.0.2 X-Spam-Level: * x-html thanks Laurie -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: FW: GWAVA Sender Notification (Spam)
Yes I received the same email about being a spammer. Somebody on the list told me that our email headers get rewritten and sometimes you get this email about being a spammer. Laurie At 02:29 PM 4/8/2005, Keith Ivey wrote: [EMAIL PROTECTED] wrote: This is what I call WAY OVER REACTING. *This member turned my email into the spam report immediately without thinking. Now I am recieving these.* I doubt that there's any connection. It's impossible to tell for sure, but the message was probably rejected because of the capital letters and multiple exclamation points in the subject line -- which means the person who posted the original complaining message probably got the same sort of bounce. -- Keith Ivey [EMAIL PROTECTED] Smokefree DC http://www.smokefreedc.org Washington, DC -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]