On Wed, Mar 31, 2010 at 12:25 AM, Carlos Mennens carlosw...@gmail.comwrote:
hearing from many admins that MySQL expects and needs there to be
three accounts for root. Them being 'localhost', 127.0.0.1, and
hostname. Is this false information?
Totally false. It's convenient, and probably all
If you only want root to be able to log in locally then you only need
'root'@'localhost' unless you are using tcp connections.
regards
John
On Tue, Mar 30, 2010 at 11:25 PM, Carlos Mennens carlosw...@gmail.comwrote:
Today I installed MySQL 5.1.45-1 on my production server and it
recommended
On Wed, Mar 31, 2010 at 3:07 AM, Johan De Meersman vegiv...@tuxera.be wrote:
On Wed, Mar 31, 2010 at 12:25 AM, Carlos Mennens carlosw...@gmail.com
wrote:
hearing from many admins that MySQL expects and needs there to be
three accounts for root. Them being 'localhost', 127.0.0.1, and
On Wed, Mar 31, 2010 at 3:52 PM, Carlos Mennens carlosw...@gmail.comwrote:
mysql CREATE USER 'carlos'@'localhost' IDENTIFIED BY 'holla';
mysql GRANT ALL PRIVILEGES ON *.* TO 'carlos'@'localhost' WITH GRANT
OPTION;
Pretty much. It's also a good idea to give that user SUPER privileges, as
Hi
I have the following fulltext search which appears to work fine for string
phrases. However if I search like just 51 which is part of the string
name like 51 Blue Widget in the table it doesn't return any results.
However if I search like bl it returns the 51 Blue Widget result. My
query is
On 31/03/2010 16:52, Tompkins Neil wrote:
Hi
I have the following fulltext search which appears to work fine for string
phrases. However if I search like just 51 which is part of the string
name like 51 Blue Widget in the table it doesn't return any results.
However if I search like bl it
Hi Mark
I did infact change the value of ft_min_word_len to 1. Rebuild the indexes
using REPAIR table name. But it didn't appear to have any affect.
Cheers
Neil
On Wed, Mar 31, 2010 at 5:29 PM, Mark Goodge m...@good-stuff.co.uk wrote:
On 31/03/2010 16:52, Tompkins Neil wrote:
Hi
I have
Hi
I found by using the REPAIR command it is now working.
Thanks,
Neil
On Wed, Mar 31, 2010 at 5:38 PM, Tompkins Neil neil.tompk...@googlemail.com
wrote:
Hi Mark
I did infact change the value of ft_min_word_len to 1. Rebuild the indexes
using REPAIR table name. But it didn't appear to
This appears to be Windows-only, at least from the .exe file that
gets downloaded.
I looked all over the site for requirements and found none.
It would be nice for all of us Windows-resisters if that requirement
had been stated somewhere up-front.
Please correct me if I'm wrong!
Hello everyone,
i am quite new to mysql and i recently begin to work with a company
who is using mysql 5.0.45 in production.
i think this version is too old and would like to upgrade to the most
recent 5.0.xx
my os is CentOS release 5.3.
is it safe to simply use yum upgrade mysql ?
are there
Hi,
I run mysqltuner this morning and I got these warning:
[!!] Key buffer size / total MyISAM indexes: 12.0G/23.2G
[!!] Key buffer hit rate: 76.9%
[!!] Query cache efficiency: 0.0%
[!!] Temporary tables created on disk: 27%
[!!] Table cache hit rate: 5%
And mysqltuner recommends to adjust these
11 matches
Mail list logo