Re: how can i login without a password although in the user-table is a password ?

gt; +----+------+---+ > > I know that this is not the best solution, I will change it. > Using mysql on a Linux-system I can login with "mysql -u root" without > supplying a password. How is this possible although there is a pa

how can i login without a password although in the user-table is a password ?

.0.1 | root | *1939D66C9255EE78C765CD91B5FB465C7A9472D9 | ++--+---+ I know that this is not the best solution, I will change it. Using mysql on a Linux-system I can login with "mysql -u root" without supplying a password. How is this po

RE: Very strange issue while trying to login remotely

Look like you have to login in with mysql_secret, set the pw, then perform your update. If this is the case, find the mysql_secret file, open/cat it, and copy the pw from the file. Then log in with that pw in the cmd line. To update the root pw, use: SET PASSWORD = PASSWORD( <>); Th

Re: Very strange issue while trying to login remotely

it will not prompt for a password with the '-p' try this: mysql --host 5.6.7.8 -uroot db_name -p I assume you do have a password set? On Mon, May 25, 2015 at 11:24 AM, Ajay Garg wrote: > Hi All. > > I have two servers, 1.2.3.4 and 5.6.7.8 > I wish to login remotely FRO

Re: Very strange issue while trying to login remotely

Sorry, The user had multiple passwords set up in mysql.user table. Clearing the "other" passwords solved the issue. Sorry for the inconvenience. Thanks and Regards, Ajay On Mon, May 25, 2015 at 8:54 PM, Ajay Garg wrote: > Hi All. > > I have two servers, 1.2.3.4 and 5.6.7.

Very strange issue while trying to login remotely

Hi All. I have two servers, 1.2.3.4 and 5.6.7.8 I wish to login remotely FROM 1.2.3.4 onto 5.6.7.8. a) On 5.6.7.8, mysql> show grants for 'root'@'%'; +-

(resolved) Re: user not able to login from localhost

friends,  i figure that i had to give password in quotes. i was then able to login. thank you all for your help and time. From: Rajeev Prasad To: Rick James ; mysql list Sent: Monday, September 24, 2012 4:11 PM Subject: Re: user not able to login from

Re: user not able to login from localhost

sql> I am looging in from the same server. From: Rick James To: Rajeev Prasad ; mysql list Sent: Monday, September 24, 2012 2:09 PM Subject: RE: user not able to login from localhost That says that your password in not correct.  You have not go

Re: user not able to login from localhost

tember 24, 2012 2:49 PM Subject: Re: user not able to login from localhost Also ensure you issue: FLUSH PRIVILEGES; after making any changes to permissions.. On 24 September 2012 20:09, Rick James wrote: > That says that your password in not correct.  You have not gotten to specific > pri

Re: user not able to login from localhost

day, September 24, 2012 10:56 AM >> To: mysql list >> Subject: user not able to login from localhost >> >> i have given select/insert/update/delete rights to a user on a specific >> database, from localhost. when i try to login to mysql using the uid, i >> get

Re: user not able to login from localhost

On Mon, Sep 24, 2012 at 1:55 PM, Rajeev Prasad wrote: > i have given select/insert/update/delete rights to a user on a specific > database, from localhost. when i try to login to mysql using the uid, i get > error: > > > > ERROR 1045 (28000): Access denied for user '

RE: user not able to login from localhost

7;; > -Original Message- > From: Rajeev Prasad [mailto:rp.ne...@yahoo.com] > Sent: Monday, September 24, 2012 10:56 AM > To: mysql list > Subject: user not able to login from localhost > > i have given select/insert/update/delete rights to a user on a specific > data

user not able to login from localhost

i have given select/insert/update/delete rights to a user on a specific database, from localhost. when i try to login to mysql using the uid, i get error: ERROR 1045 (28000): Access denied for user 'myuser'@'localhost' (using password: YES) what other privilege do i need to give this user?

Re: mysql failed login attempts

general.log > log-output=/var/log/mysqld-general.log > log=/var/log/mysqld.log > log-error=/var/log/mysqld-error.log > pid-file=/var/run/mysqld/mysqld.pid > > Yet if I tail the /var/log/mysqld-general.log I cannot see the login > attempts. > > This is how my environmen

mysql failed login attempts

r/run/mysqld/mysqld.pid Yet if I tail the /var/log/mysqld-general.log I cannot see the login attempts. This is how my environment variables are set: mysql> show variables like 'log%'; +-+---+ | Variable_name

Re: Matrix Stats Login

Oops --Original Message-- From: Tompkins Neil To: [MySQL] Subject: Matrix Stats Login Sent: Sep 24, 2010 09:41 User fifaleagues Pass DrUch929eHek9Huwa7HAcH6wRUk5QaTr -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Fwd: Matrix Stats Login

Sorry, this message was sent in error, please ignore. -- Forwarded message -- From: Tompkins Neil Date: Fri, Sep 24, 2010 at 5:41 PM Subject: Matrix Stats Login To: "[MySQL]" User Pass

Matrix Stats Login

User fifaleagues Pass DrUch929eHek9Huwa7HAcH6wRUk5QaTr

RE: login problem from django script, using python2.5/MySQLdb/connections.py

From: John Griessen [mailto:j...@industromatic.com] Sent: Wednesday, December 09, 2009 10:16 AM To: mysql@lists.mysql.com Subject: login problem from django script, using python2.5/MySQLdb/connections.py If I can login from a shell, what could stop a script from login? I'm following a newbi

Re: login problem from django script, using python2.5/MySQLdb/connections.py

John Griessen wrote: If I can login from a shell, what could stop a script from login? privileges were stopping it and at first, maybe a mistake in GRANT setup of a new user. Nevermind JG -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

login problem from django script, using python2.5/MySQLdb/connections.py

If I can login from a shell, what could stop a script from login? I'm following a newbie tutorial for django, a web content mgt. system. The following user and password are good if I use them fromthe same shell the script launches from. Here's the error message from a django scri

RE: Unable to Login to MySQL 5

20:06 To: mysql@lists.mysql.com Subject: Unable to Login to MySQL 5 Hello there, I have been using MySQL 5 on my OS X Leopard based laptop for quite some time now... Didn't have a password set and my login was "root" on localhost. Downloaded just now the Spring distribution wa

Re: Unable to Login to MySQL 5

7 PM, "James Dekker" wrote: Hello there, I have been using MySQL 5 on my OS X Leopard based laptop for quite some time now... Didn't have a password set and my login was "root" on localhost. Downloaded just now the Spring distribution was following the steps to run the

Re: Unable to Login to MySQL 5

Fixed it! Did the following: mysql -u root -p mysql> use mysql; update user set password=PASSWORD("password") where User='root'; mysql> flush privileges; mysql> quit I am now able to login using my SequelPro MySQL client! :-) Happy programming, James On Oc

Re: Unable to Login to MySQL 5

you don't need to grant anything to root, usually. cheers Claudio On Oct 14, 2009 9:07 PM, "James Dekker" wrote: Hello there, I have been using MySQL 5 on my OS X Leopard based laptop for quite some time now... Didn't have a password set and my login was "root&q

Re: Unable to Login to MySQL 5

kker" wrote: Hello there, I have been using MySQL 5 on my OS X Leopard based laptop for quite some time now... Didn't have a password set and my login was "root" on localhost. Downloaded just now the Spring distribution was following the steps to run the petclinic sample applic

Unable to Login to MySQL 5

Hello there, I have been using MySQL 5 on my OS X Leopard based laptop for quite some time now... Didn't have a password set and my login was "root" on localhost. Downloaded just now the Spring distribution was following the steps to run the petclinic sample applica

GRANT USAGE (was: Re: login issue..pls help)

what is the purpose of 'Grant usage ' command http://search.mysql.com/search?site=refman-50&q=grant+usage&lr=lang_en Check the documentation, if you have more questions after that, get back to us. With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download Database Wo

Transations? (was: Re: login issue..pls help)

Hi, (better change the message subject if you change, well, the subject) user will create more number of tickets per day. so INSERT, UPDATE, SELECT will use highly. in document says' Myisam will not support transaction but it has self backup and restoration method. but in InnoDB good for tr

Re: login issue..pls help

This particular reference is little too vague to be of much use. MyISAM may outperform innodb in signle process situations but in contentious mixed read/write traffic (suchas a typical webapp), innodb is much faster for a variety of reasons. > > 13.1. Comparing Transaction and Nontransaction Engin

RE: login issue..pls help

-transactions.html best regards liuyann > From: sac.fai...@gmail.com > Date: Thu, 1 Oct 2009 15:06:54 +0530 > Subject: Re: login issue..pls help > To: aim.prab...@gmail.com > CC: mysql@lists.mysql.com > > user will create more number of tickets per day. so INSERT,

Re: login issue..pls help

t;>>> Faizal S >>>>>> GSM : 9840118673 >>>>>> Blog: http://oradbapro.blogspot.com >>>>>> >>>>>> >>>>>> On Thu, Oct 1, 2009 at 12:28 PM, prabhat kumar >>>>> > wrote: >>>>>>

Re: login issue..pls help

e >>>>>> place that stores information about all the other databases that the >>>>>> MySQL >>>>>> server maintains. Inside INFORMATION_SCHEMA there are several read-only >>>>>> tables. They are actually views, not base tables

Re: login issue..pls help

SQL >>>>> server maintains. Inside INFORMATION_SCHEMA there are several read-only >>>>> tables. They are actually views, not base tables, so there are no files >>>>> associated with them. >>>>> >>>>> Each MySQL user has the ri

Re: login issue..pls help

the tables that correspond to objects for which the user has >>>> the >>>> proper access privileges. >>>> >>>> http://dev.mysql.com/doc/refman/5.0/en/information-schema.html >>>> >>>> b. Its depend on your requirement like your u

Re: login issue..pls help

user has >>>> the >>>> proper access privileges. >>>> >>>> http://dev.mysql.com/doc/refman/5.0/en/information-schema.html >>>> >>>> b. Its depend on your requirement like your user will perform only DML >>>> query o

Re: login issue..pls help

fman/5.0/en/information-schema.html >>> >>> b. Its depend on your requirement like your user will perform only DML >>> query or also want DDL operations. >>> >>> http://dev.mysql.com/doc/refman/5.1/en/privileges-provided.html >>> >>>

Re: login issue..pls help

oc/refman/5.1/en/privileges-provided.html >> >> >> On Thu, Oct 1, 2009 at 12:08 PM, F.A.I.Z.A.L wrote: >> >>> thanks kumar.. >>> >>> now its working >>> >>> i have another doubt >>> >>> i created an user with limited

Re: login issue..pls help

> i have another doubt >> >> i created an user with limited privilege on particular schema. >> schema name: test >> >> *mysql> create user 'test'@'%' identified by 'test'; >> mysql> grant select,insert,update,delete,create,drop on

Re: login issue..pls help

ivilege on particular schema. > schema name: test > > *mysql> create user 'test'@'%' identified by 'test'; > mysql> grant select,insert,update,delete,create,drop on test.* to 'test'@ > '%';* > > after that i login with 'te

Re: login issue..pls help

thanks kumar.. now its working i have another doubt i created an user with limited privilege on particular schema. schema name: test *mysql> create user 'test'@'%' identified by 'test'; mysql> grant select,insert,update,delete,create,drop on test.* to &#

Re: login issue..pls help

Use : mysql -u root -p (it will prompt for password) and if its not a local host also add -h ipaddress On Thu, Oct 1, 2009 at 11:01 AM, F.A.I.Z.A.L wrote: > Hi > > iam getting the following error while login into mysql server. > > andd141# mysql -u root > ERROR 1045 (28000):

login issue..pls help

Hi iam getting the following error while login into mysql server. andd141# mysql -u root ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) Can someone please help me understand why I am not able to login from root? Best Regards Faizal S G

Re: long login times?

#x27;connect_end'] - $delta['connect_start']; if( $d > 0.5 ) error_log( "Login attempt took $d seconds" ); if( mysqli_connect_error() ) error_log( "Login Timeout for $server" ); } -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: long login times?

Jed: Are you using an in-network IP to access the database ie: 127.0.0.1 192.168.98.## or are you using a public IP or full domain name ie: DB001.MY-DOMAIN.COM ... Jim > I've started logging how long my php application takes to login to > mysql, and often it's well bel

long login times?

I've started logging how long my php application takes to login to mysql, and often it's well below 1 millisecond. However, I'll sometimes get a wave of long login attempts that take 3 to 6 seconds. I've enabled skip-name-resolv, and I think that helps. There are no long run

Re: Cannot login into mysql server

From: [EMAIL PROTECTED] To: mysql@lists.mysql.com Subject: Cannot login into mysql server Description: After starting the server, logged as root into terminal, with the command 'shell> mysqld_safe --user=mysql &' I receive the message: Starting mysql deamon

Cannot login into mysql server

SEND-PR: -*- send-pr -*- SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as SEND-PR: will all comments (text enclosed in `<' and `>'). SEND-PR: From: [EMAIL PROTECTED] To: mysql@lists.mysql.com Subject: Cannot login into mysql server >Description

Cannot login to MySQL5.0 after compiling MySQL5.1

Thank You... Res, Ananda for the reponse to myquery... It works fine now.. :)

Cannot login to MySQL5.0 after compiling MySQL5.

Yes, mysql by default sets the socket file in the below directory /var/lib/mysql/mysql.sock. But why does it refer to /tmp/mysql.sock file then, as that was the error which was given when i tried to login to mysql. Is that hard-coded for MySQL5.1 source code, which is what i wanted to know

Re: Cannot login to MySQL5.0 after compiling MySQL5.1

nary > mysqlslap > so that i can execute it in the same > machine running MySQL5.0 and benchmark the same. > > But after compiling the tarball i was not able to login to mysql using : > mysql -u root -p . It gave me the below error. > Cannot connect to /tmp/mysql.sock, w

Cannot login to MySQL5.0 after compiling MySQL5.1

-community-5.1.28-0.rhel5.src.rpm and tried to get the binary mysqlslap so that i can execute it in the same machine running MySQL5.0 and benchmark the same. But after compiling the tarball i was not able to login to mysql using : mysql -u root -p . It gave me the below error. Cannot connect to /tmp/

login logger

hey, I have been playing with different ways to improve diagnostic and audit data in MySQL that don't necessarily involve source mods (ex. general log to fifo w/background parser/logger). I've come up w/the following way of logging connections to give similar data to the listener.log file in Orac

Re: MySQL Administrator Login Error

On Sat, Aug 9, 2008 at 1:08 AM, AndrewMcHorney <[EMAIL PROTECTED]>wrote: > Hello > > I entered it incorrectly in my email. > > Andrew > > > At 10:34 AM 8/8/2008, David Giragosian wrote: > >> On 8/8/08, AndrewMcHorney <[EMAIL PROTECTED]> wrote: >

Re: MySQL Administrator Login Error

Hello I entered it incorrectly in my email. Andrew At 10:34 AM 8/8/2008, David Giragosian wrote: On 8/8/08, AndrewMcHorney <[EMAIL PROTECTED]> wrote: > > Hello > > I tried to login using localhost and root as user id with no password since > I temporarily did not enter

Re: MySQL Administrator Login Error

On Fri, Aug 8, 2008 at 10:55 PM, AndrewMcHorney <[EMAIL PROTECTED]>wrote: > Hello > > I tried to login using localhost and root as user id with no password since > I temporarily did not enter one when I installed the software. I am getting > the following error message: &

Re: MySQL Administrator Login Error

On 8/8/08, AndrewMcHorney <[EMAIL PROTECTED]> wrote: > > Hello > > I tried to login using localhost and root as user id with no password since > I temporarily did not enter one when I installed the software. I am getting > the following error message: > > MySQL Err

MySQL Administrator Login Error

Hello I tried to login using localhost and root as user id with no password since I temporarily did not enter one when I installed the software. I am getting the following error message: MySQL Error Number 1045 Access denied for user '[EMAIL PROTECTED]' (using password:NO) The p

Re: MySql Administrator Tool Login

On 8/7/08, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > Hello > > I successfully installed the mysql database on my pc. I also installed the > mysql administrator tool. I am trying to login and I need some assistance. > It is asking for stored connection, server host,

MySql Administrator Tool Login

Hello I successfully installed the mysql database on my pc. I also installed the mysql administrator tool. I am trying to login and I need some assistance. It is asking for stored connection, server host, username and password. I am not sure what to put in here. When I installed the database I

RE: Can't get a login shell for some databases SOLVED

> access? > > A user is always paired with a host. Therefore your user @'localhost' > is a new user. You will have to create with same password as existing :) > > Ben That's it! Problem solved thanks so much Ben and everyone, that

Re: Can't get a login shell for some databases

Pam Astor wrote: The ANSI-SQL syntax is to just use GRANT to create users. You will still need to use GRANT twice for both users: joe@'%' and joe@'localhost'. But I find the MySql syntax for creating user with CREATE USER and then GRANT easier to follow: CREATE USER joe@'%' IDENTIFIED BY

RE: Can't get a login shell for some databases

>> One more thing, I have already created these users and don't want to mess >> their >> passwords up or break their associated php scripts access. >> >> So how do I grant users, who already have a password, localhost >> access? > > just copy the row in the mysql table > > -- > Sebastian Mend

RE: Can't get a login shell for some databases

> The ANSI-SQL syntax is to just use GRANT to create users. You will > still need to use GRANT twice for both users: joe@'%' and joe@'localhost'. > > But I find the MySql syntax for creating user with CREATE USER and then > GRANT easier to follow: > > CREATE USER joe@'%' IDENTIFIED BY 'whatev

Re: Can't get a login shell for some databases

Pam Astor wrote: A user in MySql is not just a username, but a username and a host. The host of '%' denotes all hosts accept 'localhost'. Therefore you usually require two entries for each user: CREATE USER ben@'%' INDENTIFIED BY 'ben'; CREATE USER ben@'localhost' INDENTIFIED BY 'ben'; Does

RE: Can't get a login shell for some databases

> A user in MySql is not just a username, but a username and a host. > > The host of '%' denotes all hosts accept 'localhost'. > > Therefore you usually require two entries for each user: > > CREATE USER ben@'%' INDENTIFIED BY 'ben'; > CREATE USER ben@'localhost' INDENTIFIED BY 'ben'; > > Does

RE: Can't get a login shell for some databases

> MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > would be much more easier if you would send this output here (with faked > names, passwords and hosts ...) OK...here it is: SELECT * from mysql.

Re: Can't get a login shell for some databases

A user in MySql is not just a username, but a username and a host. The host of '%' denotes all hosts accept 'localhost'. Therefore you usually require two entries for each user: CREATE USER ben@'%' INDENTIFIED BY 'ben'; CREATE USER ben@'localhost' INDENTIFIED BY 'ben'; Does this help? Ben P

Re: Can't get a login shell for some databases

Pam Astor schrieb: connectiong from shell means connecting as localhost by default, connecting from PHP can be some different server and/or PHP uses the full IP address/hostname of the server check/compare the privileges for your users for 'localhost' and '%' [...] The seventh line shows th

RE: Can't get a login shell for some databases

> connectiong from shell means connecting as localhost by default, connecting > from PHP can be some different server and/or PHP uses the full IP > address/hostname of the server > > check/compare the privileges for your users for 'localhost' and '%' I ran “SELECT * from mysql.user;” the com

Re: Can't get a login shell for some databases

problems with the php applications reading and writing data to them. I set the databases up a few weeks ago, the first one I set up, I can’t remember exactly how I set it up. Here is what I don’t understand. I’m able to login as root, and also the very first database I set up, I am able to log in

Can't get a login shell for some databases

with the php applications reading and writing data to them. I set the databases up a few weeks ago, the first one I set up, I can’t remember exactly how I set it up. Here is what I don’t understand. I’m able to login as root, and also the very first database I set up, I am able to log in to

Re: Help with HOST LOGIN PASS NAME

ou insert > new records. > > Saravanan > > > --- On Wed, 1/16/08, meridklt <[EMAIL PROTECTED]> wrote: > > > From: meridklt <[EMAIL PROTECTED]> > > Subject: Help with HOST LOGIN PASS NAME > > To: mysql@lists.mysql.com > > Date: Wednesday, January 16

Re: Help with HOST LOGIN PASS NAME

> Subject: Help with HOST LOGIN PASS NAME > To: mysql@lists.mysql.com > Date: Wednesday, January 16, 2008, 2:35 AM > Firstly I know nothing about MySQL but had to move hosts and > followed the > export from old server to import to new server and all went > well in that the >

Help with HOST LOGIN PASS NAME

d I find that info. Thanks -- View this message in context: http://www.nabble.com/Help-with-HOST-LOGIN-PASS-NAME-tp14845571p14845571.html Sent from the MySQL - General mailing list archive at Nabble.com. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Newbie Q- Mac OSX install - login to mysql not working...

rdpress on my localhost. I need to create a database on mysql. I > opened the shell and navigate to the location of mysql. I have been > using the instructions as shown below. > > $ mysql -u adminusername -p > Enter password: > > > This is where I'm stuck. No matter what ac

Newbie Q- Mac OSX install - login to mysql not working...

n of mysql. I have been using the instructions as shown below. $ mysql -u adminusername -p Enter password: This is where I'm stuck. No matter what account I use, I am unable to login to the database. My personal account is the only account on the machine, while it's not root, it has f

RE: error in login

Thanks so much Mario, this solved the problem Thanks again Hector -Mensaje original- De: Mario Guenterberg [mailto:[EMAIL PROTECTED] Enviado el: Lunes, 09 de Julio de 2007 05:41 p.m. Para: mysql@lists.mysql.com Asunto: Re: error in login On Mon, Jul 09, 2007 at 04:33:04PM -0500

Re: error in login

ccess denied for user 'web19_u1'@'db1.intranet' > (using > > password: YES)”. If I change this to –hlocalhost I can login correctly. Change the host entry to db1.intranet in your user table for the user web19_u1. I had the same problem on my mysql machine. I changed the host

RE: error in login

lto:[EMAIL PROTECTED] Enviado el: Lunes, 09 de Julio de 2007 04:50 p.m. CC: mysql@lists.mysql.com Asunto: Re: error in login Hola Hector, el problema son las 2 tuplas que mencionas, ya que debido a su jerarquia pueden hacer un conflicto que te evita conectarte correctamente, en tu caso si deseas que

Re: error in login

IA Hector -Mensaje original- De: Gerald L. Clark [mailto:[EMAIL PROTECTED] Enviado el: Lunes, 09 de Julio de 2007 02:54 p.m. Para: "Héctor S. Mendoza O." CC: mysql@lists.mysql.com Asunto: Re: error in login Héctor S. Mendoza O. wrote: Hello all… I’ve scratched my head for a w

RE: error in login

: error in login Héctor S. Mendoza O. wrote: > Hello all… I’ve scratched my head for a while on this one, so if someone > could shed some Light on it I would appreciate it very much > > > > I have an account setup, and know about the password settings regarding > hosts. The

Re: error in login

user 'web19_u1'@'db1.intranet' (using password: YES)”. If I change this to –hlocalhost I can login correctly. My problem is that the application (php based) resides both on local intranet and in internet (two different servers), remote machine is in intranet and needs ip

error in login

27;db1.intranet' (using password: YES)”. If I change this to –hlocalhost I can login correctly. My problem is that the application (php based) resides both on local intranet and in internet (two different servers), remote machine is in intranet and needs ip 10.10.10.2 to access database, an

RE: FW: How do I find all the users that are new since my last login (repost)

a session (this is in PHP) the 'login_date' BEFORE I update it with the current info. So effectively, that would be the LAST login date right? Then I need to whip up some SQL to compare all users created_on date BETWEEN that 'LAST' date and CURRENT_DATE? DÆVID > -O

Re: FW: How do I find all the users that are new since my last login (repost)

You could add an extra field called last_login_date which you'd set only once per session - at login time. At login time you'd set this to the value that exists in login_date. Then use that for comparison against created_on. Daevid Vincent wrote: I have a SQL challenge I'm

FW: How do I find all the users that are new since my last login (repost)

ecord is created the first time) I want to show a list of users who are new since my last login. But the problem is that my last login changes for every page load (i.e. it is updated so that I can guestimate if a user is logged in still or not... I consider 10m to be the window, since rarely do user

Re: How do I find all the users that are new since my last login

not updated after the record is created the first time) I want to show a list of users who are new since my last login. But the problem is that my last login changes for every page load (i.e. it is updated so that I can guestimate if a user is logged in still or not... I consider 10m to be the windo

How do I find all the users that are new since my last login

ecord is created the first time) I want to show a list of users who are new since my last login. But the problem is that my last login changes for every page load (i.e. it is updated so that I can guestimate if a user is logged in still or not... I consider 10m to be the window, since rarely do user

Secure login / set maximum of login tries

Hi, is there a way to set a maximum of login tries? Thanks, Michael Decker -- Michael Decker [EMAIL PROTECTED] TESIS SYSware GmbH http://www.tesis.de Baierbrunnerstr. 15 * 81379 Muenchen * Tel. +49 89 747377-0 -- MySQL General Mailing

Re: I cannot login MySQL Network

Takanobu Kawabe schrieb: > Hello, my name is Takanobu Kawabe. > > I have gotten a MySQL Network, and the service level is gold , I > could login MySQL Network on May 20th , > but now I can't login. I have tried some times last week, > and today

I cannot login MySQL Network

Hello, my name is Takanobu Kawabe. I have gotten a MySQL Network, and the service level is gold , I could login MySQL Network on May 20th , but now I can't login. I have tried some times last week, and today , but I cannot do it. If I try to login (U

Re: MySQL 5 - Slow Login from remote

Hi Dan, thank you. That seems to be the Problem solved. Will test it tomorrow in the Office again. But over VPN the login was more faster then without the skip-name-resolve value. Damn, that was so easy, that should i found out by myself ;-) Kai Am Donnerstag, 20. April 2006 19:13 schrieb

Re: MySQL 5 - Slow Login from remote

Check where u resolve . that could help you I guess this DNS problem ,correct me if iam wrong . --Praj On Thu, 20 Apr 2006 18:43:39 +0200 Kai Schmidt <[EMAIL PROTECTED]> wrote: > Hi @all > > i have a Problem with Login into a MySQL 5 Server. When i try to login from a > r

Re: MySQL 5 - Slow Login from remote

] section of your my.cnf file, and restarting the MySQL server software. Would easily help you identify whether DNS is the cause of your issue. Hope this helps, Dan Hi @all i have a Problem with Login into a MySQL 5 Server. When i try to login from a remote Machine into the Server, it needs

MySQL 5 - Slow Login from remote

Hi @all i have a Problem with Login into a MySQL 5 Server. When i try to login from a remote Machine into the Server, it needs up to 30 seconds. When i login from the same machine all is at it should be. After login the Server is responding normal to querys. My Environment: SuSE 10.0 MySQL

Re: How to login to MYSQL as "root" without knowing the passward

the same; In practice they are not. On Mon, 30 Jan 2006, Dan Trainor wrote: > To: sol beach <[EMAIL PROTECTED]>, mysql@lists.mysql.com > From: Dan Trainor <[EMAIL PROTECTED]> > Subject: Re: How to login to MYSQL as "root" without knowing the passward > > s

RE: How to login to MYSQL as "root" without knowing the passward

--- -Original Message- From: sol beach [mailto:[EMAIL PROTECTED] Sent: Tuesday, 31 January 2006 12:17 PM To: [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Subject: Re: How to login to MYSQL as "root" without knowing the passwa

RE: How to login to MYSQL as "root" without knowing the passward

sol beach wrote: > I've been asked to assist the folks who own the data in the database, > but folks who used to maintain it are no longer with the company. > This installation resides on a Windows 2003 server to which I have > local admin rights. > What is the most painl

RE: How to login to MYSQL as "root" without knowing the passward

Windows 2003 - try 'net stop mysql' from a commandline. Rob > -Original Message- > From: sol beach [mailto:[EMAIL PROTECTED] > Sent: Tuesday, 31 January 2006 12:47 PM > To: [EMAIL PROTECTED] > Cc: mysql@lists.mysql.com > Subject: Re: How to login to MYS

  1   2   3   >