On Saturday 31 July 2010 5:11:33 Claudio Nanni wrote:
> login as root and remove 'empty' user ,issue:
>
> delete from mysql.user where user='';
> flush privileges;
>
> mysql authentication system is logging you on as 'empty' user.
>
> you will be ok after that ;)
>
Man, thanks a ton! That wa
login as root and remove 'empty' user ,issue:
delete from mysql.user where user='';
flush privileges;
mysql authentication system is logging you on as 'empty' user.
you will be ok after that ;)
Claudio
On 8/1/2010 2:02 AM, Corey wrote:
On Saturday 31 July 2010 4:58:36 Claudio Nanni wrote:
On Saturday 31 July 2010 4:58:36 Claudio Nanni wrote:
> after login to mysql issue:
>
> select user();
> and
> select current_user();
> and post output
> you will see they dont match.
>
/usr/local/mysql/bin/mysql -h localhost -u scripts -p
Enter password:
Welcome to the MySQL monitor. Command
after login to mysql issue:
select user();
and
select current_user();
and post output
you will see they dont match.
Claudio
On 8/1/2010 1:47 AM, Corey wrote:
On Saturday 31 July 2010 4:40:14 chaim rieger wrote:
Another thing I just noticed
In your first example you are using localhost, w
On Saturday 31 July 2010 4:40:14 chaim rieger wrote:
> Another thing I just noticed
>
> In your first example you are using localhost, which probably means you are
> connecting via network
>
> The second option you don't define a host, which means you're prolly using
> socket connection
Oh, whoo
Another thing I just noticed
In your first example you are using localhost, which probably means you are
connecting via network
The second option you don't define a host, which means you're prolly using
socket connection
--
MySQL General Mailing List
For list archives: http://lists.mysql.co
On Saturday 31 July 2010 4:30:00 chaim rieger wrote:
> Just a stab but what's the max connect set to ?
>
Thanks a ton for the quick response - I'm at wits end, been working on
this for hours!
max_connections is set to 0.
(but it is also set to 0 on another server, which largely follows the
same
Just a stab but what's the max connect set to ?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Hello - I'm only moderately familiar with mysql; the following issue has me
stumped.
I just noticed that some scripts on one of my client's servers suddenly
started failing due to being no longer able to log into the mysql db.
I have not touched the mysql config on that machine in months.
The
no that would give you the count for each second interval instead of using the
interval variable 5
Aveeks floor:
FLOOR(X) Returns the largest integer value not greater than X.
1st (seconds/5) interval example
5/5=1
floor(5/5) = 1
supplied value would truncate and give you the int not greate
no that would give you the count for each second interval instead of using the
interval variable 5
Aveeks floor:
FLOOR(X) Returns the largest integer value not greater than X.
1st (seconds/5) interval example
5/5=1
floor(5/5) = 1
supplied value would truncate and give you the int not greate
11 matches
Mail list logo
