Hello.
You should start mysqld-nt with --skip-grant-tables option and
manually update the user table. Connect to server using mysql
command line client. Execute the following statements:
use mysql;
update user set Grant_priv='Y' where user='root' and host='localhost';
Restart the se
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
On Sun, 29 Aug 2004 12:26:25 -0400
Wesley wrote:
> Exit mysql. OK, then that would seem to mean that you don't have a
> root user with 'localhost' as an allowable host. As long as you can
^^
> log in as jusoz, see if you can issue this:
Thanks !!! localized the prob
> It looks like you can log in to the mysql client as root. Do you have
> permission to change the password once you're logged in?
>
> [EMAIL PROTECTED] jusoz]$ mysql -u root -p
> Enter password:
> Welcome to the MySQL monitor...
>
> mysql>USE mysql;
> Database changed.
>
> mysql>UPDATE user SET
Jose:
It looks like you can log in to the mysql client as root. Do you have
permission to change the password once you're logged in?
[EMAIL PROTECTED] jusoz]$ mysql -u root -p
Enter password:
Welcome to the MySQL monitor...
mysql>USE mysql;
Database changed.
mysql>UPDATE user SET Password = PAS
"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
> Peter,
> Actually,
>
> Mysql -uUSERNAME -pPASSWORD works just fine.
>
> Donny
And `mysql -u root -p somepassword` will not work. With the space between
-p and "somepassword", mysql will attempt to interpret "somepassword" as the
name of a database.
As to the original question, the problem app
Peter,
Actually,
Mysql -uUSERNAME -pPASSWORD works just fine.
Donny
> -Original Message-
> From: Sunmaia [mailto:[EMAIL PROTECTED]
> Sent: Monday, May 31, 2004 7:44 PM
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: RE: Root users permissions not working
>
>
hi
this may be the problem or it may just be a typo!
you are showing
#mysql -u root -psomepassword
which should be
#mysql -u root -p somepassword
(note the space after -p)
the first will not pass the password, which would explain the lack of
privileges.
Otherwise start with skip-grant-tables
r...?
> any idea?
>
> Fabrice
> - Original Message -
> From: "Nils Valentin" <[EMAIL PROTECTED]>
> To: "FT" <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>
> Sent: Monday, August 04, 2003 9:51 AM
> Subject: Re: Root
>
>
> Hi F
; any idea?
> >
> > Fabrice
> > - Original Message -
> > From: "Nils Valentin" <[EMAIL PROTECTED]>
> > To: "FT" <[EMAIL PROTECTED]>
> > Cc: <[EMAIL PROTECTED]>
> > Sent: Monday, August 04, 2003 9:51 AM
> &g
apan
>
> Thanks
> - Original Message -
> From: "Nils Valentin" <[EMAIL PROTECTED]>
> To: "FT" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Sunday, August 03, 2003 3:11 PM
> Subject: Re: Root
>
>
> Hi there,
>
&
to mention one step before re-installing anything and skipping user handling of
mysql...
initially, there's no root passwort set at all. so you came into the server without
any changes to pma configuration or any special parameter to the mysql client.
did you change that password in the phpmyad
Hi there,
First shutdown the running server.
mysqladmin shutdown
or
/etc/init.d/mysql.server stop
or
/etc/init.d/mysqld stop
(depending on your Linux distribution)
Then restart the mysql server with option "--skip-grant-tables" like this.
safe_mysqld --skip-grant-tables
You can then login
Read http://www.mysql.com/doc/en/Command-line_options.html
Start mysqld with the --skip-grant-tables option then change your root
password again, then restart mysqld, this time with out
the --skip-grant-tables
hope that helps.
Sherwin T. Ang
Tridel Technologies Incorporated
PS: you don't have t
FT wrote:
Hi everyone
I am quiet new to DB and MySql
I must have made a big mistake by changing the root @ localhost password via
phpMyAdmin and now it is impossible to connect from neither the mysql prompt
nor phpMyAdmin...
Does anyone know how to recover this problem...I did try to reinstall M
Paul,
Your probably right about him running on windows, but I have also seen this
in other situations running linux. In fact, and yes I am almost ashamed to
say, I even set one up this way in my earlier days. It was on a local
network with no internet, and the "users" were on a custom app
At 21:17 -0400 7/8/03, Roger Davis wrote:
localhost does not mean 127.0.0.1 Localhost is the socket to connect to and
has is separate from IP addresses. The % is for IP address access. That is
why there are 2 ways. I would hardly call that redundant.
Roger
That's true on Unix, but if Jim (the o
From: http://www.mysql.com/doc/en/Can_not_connect_to_server.html
"A MySQL client on Unix can connect to the mysqld server in two different
ways: Unix sockets, which connect through a file in the file system (default
`/tmp/mysqld.sock') or TCP/IP, which connects through a port number. Unix
sockets
Roger Davis wrote:
> localhost does not mean 127.0.0.1 Localhost is the socket to connect to and
> has is separate from IP addresses.
Does this mean from the machine's console, or something else?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:h
localhost does not mean 127.0.0.1 Localhost is the socket to connect to and
has is separate from IP addresses. The % is for IP address access. That is
why there are 2 ways. I would hardly call that redundant.
Roger
> -Original Message-
> From: Joel Rees [mailto:[EMAIL PROTECTED]
> Sen
> Not sure where these came from, but in my users I've got a [EMAIL PROTECTED] and a
> [EMAIL PROTECTED] Is this redundant, or is there a reason for this?
Well, some people might say it's redundant, but it _is_ by design --
http://www.mysql.com/doc/en/Privileges.html
> ...
--
Joel Rees, p
Hi,
Start the mysqld with --skip-grant-tables. This way the server will not
use the privilege tables... Then alter the data as you want and do a
mysqladmin flush-privileges (or reload) to restart using them.
More info:
http://www.mysql.com/doc/en/Privileges_options.html
On Fri, 2003-01-17 at 03:
On Saturday 14 December 2002 23:07, tlr7425 at garnet dot acns dot fsu dot edu
wrote:
> how exactly do I change the Root user's password for mysql?
>
> like this? :
>
> mysqladmin -u root -p'newpasswd' ? (without a space between -p and
> 'newpasswd' ?)
>
> and, if that is correct, I guess I'd
After loging in mysql as root, enter the command:
SET PASSWORD FOR root=password('the_new_password');
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, December 14, 2002 5:07 PM
> To: [EMAIL PROTECTED]
> Subject: Root user password changing
>
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.
Alex,
Monday, August 19, 2002, 3:38:07 PM, you wrote:
AM> I Have a problem with logining to MySQL with root. I am runnig Red Hat
AM> Linu 7.3 and I just have installed MySQL 3.23.49 frjm the rpm package,
AM> which I got with Red Hat Linux 7.3.
AM> So I read documentation an made as following:
Hello,
I really hope that Red Hat hasn't changed the root default password to
something else.
Start mysqld with --skip-grant-tables parameter, then try your mysqladmin
command you were trying to execute. If it works then, your grant tables
are screwed up somehow.When you're running with --skip-g
Leonard,
Saturday, July 20, 2002, 4:50:32 PM, you wrote:
LM> mysql version 3.23.41 On Redhat 7.2
LM> I was trying to get this setup so I could limit access to future
LM> databases,
LM> and I think I locked my root account out.
LM> I tried restarting with "/etc/rc.d/init.d/mysqld start
LM> --sk
"Leonard Miller" <[EMAIL PROTECTED]> writes:
> mysql version 3.23.41 On Redhat 7.2
> I was trying to get this setup so I could limit access to future
> databases,
> and I think I locked my root account out.
> I tried restarting with "/etc/rc.d/init.d/mysqld start
> --skip-grant-tables", but
"Leonard Miller" <[EMAIL PROTECTED]> writes:
> mysql version 3.23.41 On Redhat 7.2
> I was trying to get this setup so I could limit access to future
> databases,
> and I think I locked my root account out.
> I tried restarting with "/etc/rc.d/init.d/mysqld start
> --skip-grant-tables", but I do
[admin admin]$ mysql mysql
or once you have the mysql prompt type: use mysql
then issue the command
Curtis
Page Works Web Solutions said:
> Hi,
>
> any ideas on this one
>
> [admin admin]$ mysql
> Welcome to the MySQL monitor. Commands end with ; or \g.
> Your MySQL connection id is 7 to ser
On Wednesday, 3. July 2002 07:51, Page Works Web Solutions wrote:
Hi,
>
> Type 'help;' or '\h' for help. Type '\c' to clear the buffer
>
> mysql> UPDATE user SET Password=PASSWORD(testpassword)
> -> WHERE User='root';
> ERROR 1046: No Database Selected
> mysql>
1) select the database with "u
it's in the docs.
use mysql;
or
update databasename.tablename ...
- Original Message -
From: "Page Works Web Solutions" <[EMAIL PROTECTED]>
To: "MySql mailing list (E-mail)" <[EMAIL PROTECTED]>
Sent: Wednesday, July 03, 2002 1:51 PM
Subject: Root pass
Hi,
any ideas on this one
[admi
Try
mysql -u root mysql -p
*
* Cal Evans
* The Virtual CIO
* http://www.calevans.com
*
-Original Message-
From: Page Works Web Solutions [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 02, 2002 11:02 PM
To: MySql mailing list (E-mail)
Subject: root passwords
Hi all,
MySql on linux b
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: '
Hi shawn,
You have probably have % in the user and host of the user table, so mysql
client let you in without a username. To be able to use mysql database, you
have to login as the root user. Just type, mysql -u root -p and see if you
can login in that way.
Besides, you have to restart mysqld fr
Hi
Not sure here, but you have logged in as 'admin' on the system. Unless you
su to root mysql will use the same user.
try either
[admin admin]$ su -l
to log in to the system as root and then 'mysql -p' to log into mysql
or stay as admin but log into mysql as root, under mysql
[admin admin]$
Hi Jesse,
On Sat, Jun 22, 2002 at 03:42:57AM -0500, Jesse Angell wrote:
> Hello,
> In phpmyadmin I accidentaly gave root no privlegaes.. Now I cannot do
> anything as phpmyadmin wont work because root can't do anything at all... I
> have complete ssh access etc to the server, Please help me o
Thank you Ray, this worked!
Colin
on 6/11/02 2:59 PM, Ray at [EMAIL PROTECTED] wrote:
> mysql --password
> (or just -p)
>
> On Tuesday 11 June 2002 7:30, you wrote:
>> When I try to connect to mysql as 'root' I get the following:
>>> [localhost:/Users/cooldaze] root# mysql
>>> ERROR 1045: Ac
Add -p to the command line.
[localhost:/Users/cooldaze] root# mysql -p
On Tuesday 11 June 2002 09:30, Colin Cooler wrote:
> When I try to connect to mysql as 'root' I get the following:
> >[localhost:/Users/cooldaze] root# mysql
> >ERROR 1045: Access denied for user: 'root@localhost' (Using pas
Miretsky,
Wednesday, May 22, 2002, 8:41:57 PM, you wrote:
M> I tried to create a password for the root user in a new installation of
M> MySQL by typing
M> % mysql -u root mysql
M> Then typing and update statement like
M> Update user set password = "somepassword" where user="root";
You must use
yes, you needed to use the PASSWORD( ) function
mysqladmin -h hostname -u user password 'new password'
-Ryan Hatch
"Miretsky, Anya" wrote:
> I tried to create a password for the root user in a new installation of
> MySQL by typing
> % mysql -u root mysql
> Then typing and update statement li
I've been watching this thread and wonder if not following instructions may be
contributing to the present confusion.
On Fri, 15 Mar 2002 14:38:02 +0200, Egor Egorov wrote:
>>>Show me the output of the following:
>>> SHOW GRANTS FOR 'username'@'hostname';
>
>RQ> output:
>RQ> mysql> show gra
Rob,
Thursday, March 14, 2002, 10:15:54 PM, you wrote:
>>Show me the output of the following:
>> SHOW GRANTS FOR 'username'@'hostname';
RQ> output:
RQ> mysql> show grants for 'root@localhost';
RQ> ERROR 1064: You have an error in your SQL syntax near
RQ> 'grants for 'root@localhost'' at lin
>>Show me the output of the following:
>> SHOW GRANTS FOR 'username'@'hostname';
output:
mysql> show grants for 'root@localhost';
ERROR 1064: You have an error in your SQL syntax near 'grants for 'root@localhost'' at
line 1
I noticed that my user table doesn't seem to have all the fields it
--- Simon Green <[EMAIL PROTECTED]> wrote:
> Hi Jeff
> As long as you have a user that has access to all of
> MySQL and can enter
> from root on the systems, what you call it is not
> important.
> Infact it is a good thing to change the root user
> name for security.
> Simon
Thanks for the respon
Hi Jeff
As long as you have a user that has access to all of MySQL and can enter
from root on the systems, what you call it is not important.
Infact it is a good thing to change the root user name for security.
Simon
-Original Message-
From: Jeff Corliss [mailto:[EMAIL PROTECTED]]
Sent:
> Some how I don't have control over mysqld as root. It starts on
> boot, but I
> am unable to stop it to reset root password. How can I correct this?
http://www.bitbybit.dk/mysqlfaq/faq.html#ch7_2_0
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk MySQL FAQ
http://www.
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";
-
[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, July 12, 2001 8:48
Subject: Re: Root Login Problem
> > [root@mail mysql]# mysqladmin -password FalsePass
>
> This is not as per documentation. Documentation says --password.
>
>
> - Original Message
> [root@mail mysql]# mysqladmin -password FalsePass
This is not as per documentation. Documentation says --password.
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, July 12, 2001 0:26
Subject: R
Neil Barnes
<[EMAIL PROTECTED]To: [EMAIL PROTECTED]
On Wed, Jun 13, 2001 at 04:56:23PM -0400, RIDLEY, JAMES A. (AIT) wrote:
Hi,
> I somehow locked out the root account from MySQL. How can I get access back
> as root on the Unix system?
Try this :
/path/to/mysql-directory/libexec/mysqld --skip-grant-tables
In a second term, just run mysql -p -
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.
71 matches
Mail list logo
