Marten Lehmann <[EMAIL PROTECTED]> wrote:
> security problem? Is there any way to trick the mysql-server, so that a
> remote-client can claim to be a localhost-client and thus can connect as
> mysql-user root?
No.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensi
On Wed, 15 Sep 2004 17:48:50 +0200, Marten Lehmann <[EMAIL PROTECTED]> wrote:
> I don't want to allow either. That's why I'm asking. From outside, noone
> can connect as root directly. And as noone has access to localhost
> through ssh or whatever, noone except me can login as root. My question
> w
Hi,
I would never allow anyone except myself to connect to my MySQL server
as the root MySQL user.
I don't want to allow either. That's why I'm asking. From outside, noone
can connect as root directly. And as noone has access to localhost
through ssh or whatever, noone except me can login as root
On Wed, 15 Sep 2004 17:10:27 +0200, Marten Lehmann <[EMAIL PROTECTED]> wrote:
> imagine the following setup:
>
> - a mysql-server
> - a client on a different host
>
> Privileges on the mysql-server are setup in a manner, that users can
> connect from every host, but not from localhost (and they d
"DBS" <[EMAIL PROTECTED]> wrote:
> I have a problem, It's been months since I used MySQL and (I believe) I had
> set it up with a root password. Now I can't log on to MySQL as root MySQL
> user and create a new user or manage an existing user (I can log onto server
Familiar situation. :)
Do so:
Hi
the usual syntax is mysql -u root -p
if that does not work look into
skip grant tables option
http://dev.mysql.com/doc/mysql/en/Resetting_permissions.html
HTH
Peter
> -Original Message-
> From: DBS [mailto:[EMAIL PROTECTED]
> Sent: 23 August 2004 03:50
> To: [EMAIL PROTECTED]
>
Frank Bax wrote:
At 08:25 PM 6/8/04, Frank Bax wrote:
According to the docs, one of the first things I'm supposed to do is
give root a password:
shell> mysql -u root mysql
mysql> SET PASSWORD FOR [EMAIL PROTECTED]('new_password');
I did that and now I get:
# mysql --user=root --password=new_passw
At 08:25 PM 6/8/04, Frank Bax wrote:
According to the docs, one of the first things I'm supposed to do is give
root a password:
shell> mysql -u root mysql
mysql> SET PASSWORD FOR [EMAIL PROTECTED]('new_password');
I did that and now I get:
# mysql --user=root --password=new_password
ERROR 1045: A
On Sat, 26 Oct 2002 [EMAIL PROTECTED] wrote:
> Hi,
>
> I am learning MySql and was going through the manual.html in the
> /usr/share/doc/mysql.../Docs/ I know SQL already and made some
> changes to the user table of mysql database. The server is running but I
> cant get a privileged access.
Page,
Tuesday, July 02, 2002, 9:23:16 AM, you wrote:
PWWS>I'm still stuck. If anyone has time, please take a look at this session
PWWS> I had and any pointers would be great. I just went to mysql.com to search
PWWS> the problem, but no site there..Weird.
http://www.mysql.com/doc/A/
Hi,
I'm still stuck. If anyone has time, please take a look at this session
I had and any pointers would be great. I just went to mysql.com to search
the problem, but no site there..Weird.
thanks all,
Shawn
[root /root]# mysql -u root -p
Enter password:
ERROR 1045: Access denied for user: '
At 17:44 28-8-01 -0700, Gregg Baker wrote:
>Hi all, I just joined list. I spent a couple hours in the archive and
>decided MySQL better improve their install message regarding setting the
>root password! Half the posts are about it going badly. ;)
When installing from source you will get a messag
Date |Tue, 28 Aug 2001 19:09:49 -0700
>From |"Gregg Baker" <[EMAIL PROTECTED]>
Hello!
GB> Hi all, I got a "No Database Chosen". What's the syntax for adding the
GB> database? I tried *.*, mysql, and test between UPDATE and user but all
GB> returned syntax error.
GB> Thanks much, Gregg
GB> UPDA
Hi all, I got a "No Database Chosen". What's the syntax for adding the
database? I tried *.*, mysql, and test between UPDATE and user but all
returned syntax error.
Thanks much, Gregg
UPDATE user SET Password=PASSWORD("desiredpasswordhere") WHERE User="root";
-
On Thu, 31 May 2001, Jean-Philippe Durrios wrote:
> Hi,
> How do I set the root password after installing MySQL server and client?
> I followed the after installation instructions,@they don'T work.
>
> mysqladmin -p password 'new-password' I don't get it.
The message from the RPM file is w
They do work. Just need to follow instruction a little more closely, though
I will agree with, the instructions do trip up many beginners. Remove
the -p switch. It is only used if you have already set a password but since
you haven't ...
Also quotes around new-password aren't required.
-
On Thu, 19 Apr 2001, feldekis wrote:
> ./bin/mysql -p -user=root
> Enter password: password
> ERROR 1045: Access denied for user: 'ser=root@localhost' (Using password: YES)
^
mysql -p -u root, not mysql -p -user=root
pz
--
Bartosz Sienkiewicz
---
http://www.mysql.com/doc/R/e/Resetting_permissions.html
-
Ken Menzel ICQ# 9325188
www.icarz.com [EMAIL PROTECTED]
- Original Message -
From: "Mr.Mongkol Phitaksuksanti" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, April 1
http://www.mysql.com/doc/R/e/Resetting_permissions.html
-
Ken Menzel ICQ# 9325188
www.icarz.com [EMAIL PROTECTED]
- Original Message -
From: "Sandeep Pachpande" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, April 12, 2001
At 15:13 12.04.2001, Sandeep Pachpande wrote:
>Hi,
>
>I have one problem regarding database creation.
>I am using MySQL on FreeBSD unix os.
>I have already created two databast in mysql.
>Now I want to create new database for same but i forgot my root mysql
>password.
>
>Please help me.
>Thanks i
>Now I want to create new database for same but i forgot my root mysql
>password.
Take a look at the manual. It's there, so USE it.
You can also find the answer in this lists archive.
Bye,
B.
-
Before posting, please chec
It is in the manual.
Sandeep Pachpande wrote:
>
> Hi,
>
> I have one problem regarding database creation.
> I am using MySQL on FreeBSD unix os.
> I have already created two databast in mysql.
> Now I want to create new database for same but i forgot my root mysql password.
>
> Please help me.
22 matches
Mail list logo