On Wed, Mar 31, 2010 at 12:25 AM, Carlos Mennens 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
> hostname. Is this false information?
>
Totally false. It's convenient, and probably all of their scripts
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 wrote:
> Today I installed MySQL 5.1.45-1 on my production server and it
> recommended that I run the follo
On Wed, Mar 31, 2010 at 3:07 AM, Johan De Meersman wrote:
> On Wed, Mar 31, 2010 at 12:25 AM, Carlos Mennens
> 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
>> hostname. Is this false information?
On Wed, Mar 31, 2010 at 3:52 PM, Carlos Mennens wrote:
> 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
that'll allow you t
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
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 r
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 wrote:
> On 31/03/2010 16:52, Tompkins Neil wrote:
>
>> Hi
>>
>> I have the following
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 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 have any affect.
>
> Cheers
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 a
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 s
11 matches
Mail list logo
