On 3/16/2012 2:41 PM, Clemens Eisserer wrote:
Hi Shawn,
I understand the logic behind seperating local and remote users,
postgresql does the same thing in its pg_hba.conf file.
However, what I don't understand is the way this turned out to be such
a huge problem (for me), as it worked already wi
Hi Clemens,
my pleasure!
I forgot, you had to use also -P3306, so using both -h and -P which deny
the lookup for users at localhost,
forcing TCP-IP. and so IPs.
this is also good when the socket file is not in the standard location, you
will have the same problem logging in locally,
using -h and
Hi Shawn,
I understand the logic behind seperating local and remote users,
postgresql does the same thing in its pg_hba.conf file.
However, what I don't understand is the way this turned out to be such
a huge problem (for me), as it worked already with MySQL-5.1 a few
years ago. I've worked with o
Hi Claudio,
> you probably have the anonymous user account taking over: ''@'localhost'
> login as root and:
> mysql> drop user ''@'localhost';
Thanks a lot, that solved the problem (and saved my day :) !).
> when you specify the host with -h you are actually forcing MySQL to use
> TCP/IP so it
On 3/16/2012 7:00 AM, Clemens Eisserer wrote:
Hi Rik,
Hm, is the mysql-client library the same as the mysql-server?
Yes.
And does mysql --host=127.0.0.1 --user=someone -p somedb work (or it's actual
IP-address, forcing the TCP/IP connect instead of possible sockets) ?
This is really strang
> > Hm, is the mysql-client library the same as the mysql-server?
>
> Yes.
Aight...
> > And does mysql --host=127.0.0.1 --user=someone -p somedb work (or it's
> > actual IP-address, forcing the TCP/IP connect instead of possible
> > sockets) ?
>
> This is really strange - with -h127.0.0.1 I get
If you want to verify it is very easy:
$ mysql --user=someone somedb (without -p)
mysql> select user(); select current_user();
cheers
Claudio
2012/3/16 Claudio Nanni
> you probably have the anonymous user account taking over: ''@'localhost'
>
> when you specify the host with -h you
you probably have the anonymous user account taking over: ''@'localhost'
when you specify the host with -h you are actually forcing MySQL to use
TCP/IP so it will authenticate you using your ip address (127.0.0.1)
login as root and:
mysql> drop user ''@'localhost';
and try again
Cheers
Claud
Hi Rik,
> Hm, is the mysql-client library the same as the mysql-server?
Yes.
> And does mysql --host=127.0.0.1 --user=someone -p somedb work (or it's actual
> IP-address, forcing the TCP/IP connect instead of possible sockets) ?
This is really strange - with -h127.0.0.1 I get the same error:
ERR
omedb.* TO 'someone'@'.' IDENTIFIED BY 'somepass';
cheers
Claudio
2012/3/16 Clemens Eisserer
> Hi,
>
> All I would like to do is the create a small database with a non-root
> user which is allowed to access the db, however after hours of trying
> I gave
> Hi Rik,
>
> > Have you tried the _full_ user-identification (which is with host)?
> >
> > GRANT ALL ON somedb.* TO 'someone'@'%';
>
> Yes I had (and just tried to verify) but it didn't help.
Oops, didn't use reply-to-list instead of reply-to-author, my apologies...
> Could it be Fedora's mys
Hi Rik,
> Have you tried the _full_ user-identification (which is with host)?
>
> GRANT ALL ON somedb.* TO 'someone'@'%';
Yes I had (and just tried to verify) but it didn't help.
Could it be Fedora's mysql packages are special somehow?
Re-installing mysql after deletig its data-directory didn't
Hi,
All I would like to do is the create a small database with a non-root
user which is allowed to access the db, however after hours of trying
I gave up.
I am using MySQL-5.5.20 on Fedora16 .
CREATE USER 'someone'@'%' IDENTIFIED BY 'somepass';
CREATE DATABASE so
On 21.12.2010 11:27 CE(S)T, 杨涛涛 wrote:
> Maybe you should give a password to MySQL's root. And I think this note will
> disappear.
I would be extremely dumb not to set any password on MySQL's root
account at all! Of course (I hope I made that clear before) a password
has been set while installing
Maybe you should give a password to MySQL's root. And I think this note will
disappear.
David Yeung, In China, Beijing.
My First Blog:http://yueliangdao0608.cublog.cn
My Second Blog:http://yueliangdao0608.blog.51cto.com
My Msn: yueliangdao0...@gmail.com
2010/12/17 Yves Goergen
> On 14.12.2010
On 14.12.2010 20:36 CE(S)T, Alejandro Bednarik wrote:
> Are you using ubuntu deb's or mysql bin? Do you get that message when
> the service start? Look init script to see what it does.
I get the message when MySQL is started. I've installed the Ubuntu
standard package mysql-server-5.1. It has alr
On 13.12.2010 15:26 CE(S)T, who.cat wrote:
> try /mysql_bin_path/mysql_secure_installation !
> Hope it helpfu!
I already followed that path and it doesn't quite help. I've done the
checks that the install script does and my installation is secure by
those means. But I don't want to install things
Hi,
I find the following line in my syslog events:
Daemon Error mysqld
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
followed by a whole lot of notes, advice and web links. I do have set a
custom password for root, root is not accessible from remote, the
anonymous user does not
ions about this on the web but no
>> resolution yet.
>>
>>
>> When MySQL runs out of threads, you are unable to stop /
>> restart the database.
>>
>>
>> Is there a way to reserve threads for the root user /
>> database restarts?
>&
database.
Is there a way to reserve threads for the root user /
database restarts?
Yes. Don't give normal users the SUPER privilege.
http://dev.mysql.com/doc/refman/5.1/en/privileges-provided.html#priv_super
Your applications and non-administrative users should be using acc
threads for the root user /
database restarts?
Current version running: 5.0.72sp1-enterprise-gpl-log
Machiel Richards
MySQL DBA
Relational Database Consulting
RDC_Logo
Hello,
(First let me remember that my OS is Ubuntu 9.04)
I've found a solution today few minutes ago, so I'm posting here since I've
sound so many posts around the web and not a single solution seemed to solve
my problem.
Its actually pretty simple. My real problem was related to the my.cnf and
Hello MySQL Community,
I'm new around, and I'm a new mysql user. I use mysql mostly together with
Moodle to support many courses on a public university in Brazil (UFBA).
Recently, I was trying to use Reverse Engineering on Workbench to catch a
relationship diagram for moodle, and so I've attempte
- Original Message -
From: "Daniel da Veiga" <[EMAIL PROTECTED]>
To:
Sent: Thursday, December 07, 2006 9:48 AM
Subject: Re: Renaming the root user - problems.
> On 12/7/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> > Hello,
> >
> > my
On 12/7/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
Hello,
my question refers to the user "root" in MySQL 5.0.22.
Is the standard MySQL root user really required with the name "root" or can I rename the
root user for example to "myroot"?
No, it
[EMAIL PROTECTED] schrieb:
Hello,
my question refers to the user "root" in MySQL 5.0.22.
Is the standard MySQL root user really required with the name "root" or can I rename the
root user for example to "myroot"?
Our software vendor affirms that MySQL need the
Hi
No. MySQL doesn't insist on any 'root' user. If necessary you can rename
it. If you have the supervisor privileges, you can edit the same. Make
sure to Grant Permissions.
For instance: mysql> grant all on *.* to 'myroot'@localhost identified by
'm
Hello,
my question refers to the user "root" in MySQL 5.0.22.
Is the standard MySQL root user really required with the name "root" or can I
rename the root user for example to "myroot"?
Our software vendor affirms that MySQL need the User "root&quo
Murray @ PlanetThoughtful wrote:
[EMAIL PROTECTED] wrote:
Hi Shawn,
Sorry, I'm talking about "root" the MySQL user account. The account
exists -- I can perform the following, for example:
c:>mysql --user=root ptnew -p
Once I supply the password, this will put me in to the ptnew database,
[EMAIL PROTECTED] wrote:
"Murray @ PlanetThoughtful" <[EMAIL PROTECTED]> wrote on 11/11/2005
08:44:37 PM:
Hi All,
I recently upgraded from MySQL 4.1.14 to 5.0.15 on my WinXP machine.
For some reason my root login can't access the mysql database anymore,
though I can use it to access the
"Murray @ PlanetThoughtful" <[EMAIL PROTECTED]> wrote on 11/11/2005
08:44:37 PM:
> Hi All,
>
> I recently upgraded from MySQL 4.1.14 to 5.0.15 on my WinXP machine.
>
> For some reason my root login can't access the mysql database anymore,
> though I can use it to access the databases I have de
Hi All,
I recently upgraded from MySQL 4.1.14 to 5.0.15 on my WinXP machine.
For some reason my root login can't access the mysql database anymore,
though I can use it to access the databases I have defined. In effect,
it seems as though I have no real root (or administrator level, if
that's
I had no problem installing mysql as a simple user in my home directory
on a linux x86_64 machine either from source or binary.
I did this:
1.Download binary or source from MySQL mirror
2.Untar into a directory database_dir or make install using ./configure
-âprefix=database_dir
3.Softlink database
ked
> through the installation documentation, and have also successfully
> performed MySQL installations on WindowsXP (along with Apache and
> PHP), as well as on Linux machines that I have administrative (root)
> access on. However, I am having problems installing MySQL on a Linux
> machin
> -Original Message-
> From: j [mailto:[EMAIL PROTECTED]
> Sent: dinsdag 1 februari 2005 11:20
> To: Mark
> Cc: mysql@lists.mysql.com
> Subject: Re: Non root user MySQL install possible?
>
> Sorry, I don't mean running MySQL as root, I mean I do not have roo
Sorry, I don't mean running MySQL as root, I mean I do not have root
access on the server I am trying to install MySQL on - for myself,
under my home directory. I run into permission problems (because I am
not root, I can't alter anything under /var). I am trying to edit the
necessary configs so th
> -Original Message-
> From: j [mailto:[EMAIL PROTECTED]
> Sent: dinsdag 1 februari 2005 10:09
> To: mysql@lists.mysql.com
> Subject: Non root user MySQL install possible?
>
> Hi. Before asking my question I would like to state that I have looked
> through the in
having problems installing MySQL on a Linux
machine as a non root user. My question is: is it possible? I don't
see why it wouldn't be, but after fighting with setting the correct
paths in mysql.server, and making sure ~/.my.cnf looked right, I am
having doubts. Rather than list every e
start up Easy PHP with [EMAIL PROTECTED] If I try to work with
>other users by the user parameter in config.inc.php, PHPmyAdmin doesn't
>work.
>2 - I switch off the Grant option to the ROOT user with EasyPHP and now I
>can't reset ON the Grant option to ROOT user even if
#x27;t
work.
2 - I switch off the Grant option to the ROOT user with EasyPHP and now I
can't reset ON the Grant option to ROOT user even if I use the procedure
(Stop mysql services and enter mysqld-nt command and so on, in fact the
mysqld works but not mysqld-nt..) or by the GRANT SQL command
MueR wrote:
From: Michael Stassen [mailto:[EMAIL PROTECTED]
Subj: Re: Access denied for root user
MueR wrote:
Hello,
I've recently had my HD crash, and have reinstalled everything.
Everything seems to work fine, apart from one thing. My MySQL server
has decided to randomly set a root pas
From: Michael Stassen [mailto:[EMAIL PROTECTED]
Subj: Re: Access denied for root user
> MueR wrote:
>
>> Hello,
>>
>> I've recently had my HD crash, and have reinstalled everything.
>> Everything seems to work fine, apart from one thing. My MySQL server
&g
MueR wrote:
Hello,
I've recently had my HD crash, and have reinstalled everything.
Everything seems to work fine, apart from one thing. My MySQL server
has decided to randomly set a root password.
No, it didn't. I know it seems that way, but I'm sure that's not what happened.
I have tried loggin
Hello,
I've recently had my HD crash, and have reinstalled everything.
Everything
seems to work fine, apart from one thing. My MySQL server has decided to
randomly set a root password.
I have tried logging in with no password, tried it with my old password.
Tried
restarting the server with th
packages for Mac OS X:
mysql-max-4.0.l8.pkg
MySQLStartupItem.pkg
no problem.
But then when trying to configure the root user for the
db, cut and paste straight from Chapter 2 of the manual
fails:
mysql_install_db created users [EMAIL PROTECTED] and [EMAIL PROTECTED]
without paswords. The foll
warning: complete db server newbie!
(I've done plenty of SQL & JDBC coding, but never
had to care about the server side until now ;-)
Installed the binary distribution packages for Mac OS X:
mysql-max-4.0.l8.pkg
MySQLStartupItem.pkg
no problem.
But then when trying to configure the
"Victoria Reznichenko" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> "Marcin Blazowski" <[EMAIL PROTECTED]> wrote:
> > "Marcin Blazowski" <[EMAIL PROTECTED]>> wrote:
> >>> I've created a database and a user with ALL PRIVILEGES and GRANT
OPTIONS
> To be able give permissions to oth
Hi!
On Jul 14, Marcin Blazowski wrote:
> >> mysql> grant all privileges on temp.* to [EMAIL PROTECTED] identified by 'haslo'
> >> with grant option;
> >> mysql> grant insert on temp.* to [EMAIL PROTECTED] identified by 'haslo';
> >> ERROR 1044: Access denied for user: '[EMAIL PROTECTED]' to datab
"Marcin Blazowski" <[EMAIL PROTECTED]> wrote:
> "Marcin Blazowski" <[EMAIL PROTECTED]>> wrote:
>>> I've created a database and a user with ALL PRIVILEGES and GRANT OPTIONS
> to
>>> that database. When logon with that new user and want to create a new
> user
>>> with some privileges a get an error.
[EMAIL PROTECTED]
|
| cc:
|
| Subject: Re: Problem with adding a new user by non root user
"Marcin Blazowski" <[EMAIL PROTECTED]> wrote:
> I've created a database and a user with ALL PRIVILEGES and GRANT OPTIONS to
> that database. When logon with that new user and want to create a new user
> with some privileges a get an error.
>
> How I do it:
>
> mysql> grant all privileges on temp.
Hi!
I've created a database and a user with ALL PRIVILEGES and GRANT OPTIONS to
that database. When logon with that new user and want to create a new user
with some privileges a get an error.
How I do it:
mysql> grant all privileges on temp.* to [EMAIL PROTECTED] identified by
'haslo' with grant
You state that you searched the web and the documentation, but did you
search the MySQL manual?
4.2 General Security Issues and the MySQL Access Privilege System
http://www.mysql.com/doc/en/Privilege_system.html
4.3 MySQL User Account Management
http://www.mysql.com/doc/en/User_Account_Management
I have just set up MySQL and the phpmyadmin script and I would like to add
some users and do some other administrative tasks to assure security. Above
all, I want to make sure no user (or php script) will have access to any
databases without a user name and password.
Right now if I look at the
On Tuesday 21 January 2003 16:06, Alejandro C. Garrammone wrote:
> The problem is this. Always when I start the server, when I try to show the
> table mysql, I get an error message that saids "Access Denied to user "
> but when I put the same command with the --user=root it works.
> the questi
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Alex --
...and then Alejandro C. Garrammone said...
%
% The problem is this. Always when I start the server, when I try to show the
% table mysql, I get an error message that saids "Access Denied to user "
% but when I put the same command with t
The problem is this. Always when I start the server, when I try to show the
table mysql, I get an error message that saids "Access Denied to user "
but when I put the same command with the --user=root it works. the question
is: How can I start the server whit root priviledges?
thxs.
Alex.
-
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:
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 then be presented with a prompt
for the old passwd, right?
Then, the new one would take effect?
T
just starting to work with MySql on MAC OS X.When i
> installed mysql i got the following message :
>
> PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! This is
> done with: /usr/local/bin/mysqladmin -u root -p password 'new-password'
> /usr/local/bin/mysqladmin
On Monday, September 30, 2002, at 03:03 24h, Palash Mohanlal Kasodhan
wrote:
> Hi everyone,
> I am just starting to work with MySql on MAC OS X.When i
> installed mysql i got the following message :
>
> PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
Hi everyone,
I am just starting to work with MySql on MAC OS X.When i
installed mysql i got the following message :
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! This is
done with: /usr/local/bin/mysqladmin -u root -p password 'new-password'
/usr/local/bin/mys
Hi,
we want to lock the Memory which the MySQL allocs.
We use the memlock option in the my.cnf file but it wont work
so we expected. Now we run the MySQL as user root (user entry in the
my.cnf) and it works.
In the documentation stood that running the MySQL under the root user is not good,
but
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 u
> -Original Message-
> From: Gurhan Ozen [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, May 22, 2002 5:58 PM
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: RE: change default root user name?
>
>
> Hi,
> You should be able to do it with a tweak.. You can c
PROTECTED]]
Sent: Wednesday, May 22, 2002 5:27 PM
To: [EMAIL PROTECTED]
Subject: change default root user name?
I've had a question that I haven't really seen addressed anywhere...
Is it okay to change the default "root" user name to a different name? Any
issues involved by d
I've had a question that I haven't really seen addressed anywhere...
Is it okay to change the default "root" user name to a different name? Any
issues involved by doing so?
The reason I ask is that it seems to me that, because everyone knows that
MySQL installs with the r
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
>
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 like
> Update user set password = "somepassword" where user="root";
After doing this I typed because I could still get into m
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 like
> Update user set password = "somepassword" where user="root";
After doing this I typed because I could still get into m
I think the general procedure is the same, just a couple things you have
to consider.
1. The mysql daemon will have to run under your user name.
2. You might not be able to use port 3306, you'll have to check with the
sys admin for this.
3. You'll have to install it into your home directory ( che
I have an account on our Dec Unix system and I can't find any directions
on how to make MySQL work without root privileges. Can it be done?
pj
--
Paul E. Johnson email: [EMAIL PROTECTED]
Dept. of Political Sciencehttp://lark.cc.ukans.edu/~pauljohn
University of
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
as root. When I try to perform a GRANT
statement, I get the error message "ERROR 1045: Access denied for user:
'root@localhost' (Using password: YES)"
RQ> Any ideas why root is not allowed rights? How do I give root user root access?
Did I set up mysql incorrectly fr
t allowed rights? How do I give root user root access?
Did I set up mysql incorrectly from the start? The root user seems to be able to do
everything else.
You can use GRANT statement if you set GRANT OPTION for your user. So
it looks like that your mysql user don't have privileges to s
3.22.32 and logged in as root. When I try to perform a GRANT
statement, I get the error message "ERROR 1045: Access denied for user:
'root@localhost' (Using password: YES)" Any ideas why root is not allowed rights?
How do I give root user root access? Did I set up mysql
you feel a need to make a
smart-ass remark, then do so, then use your backspace key to remove it.
-Original Message-
From: Van [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 04, 2002 12:02 AM
To: MySQL
Subject: Re: Help, Root User Password Lost!
zhu cathy wrote:
>
> Hello Friend
http://www.alt-php-faq.org/local/70/
-Original Message-
From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]]
Sent: 04 February 2002 11:30
To: [EMAIL PROTECTED]
Subject: Help, Root User Password Lost!
zhu,
Monday, February 04, 2002, 7:24:22 AM, you wrote:
zc> Hello Friends:
zc&
zhu cathy wrote:
>
> Hello Friends:
>
> My root user password get lost. I just can't get in
> the database again.
> Anyone know the way to get access to mysql without
> password. Or is there a way to change the password?
> I get access denied with the Error No
Hello Friends:
My root user password get lost. I just can't get in
the database again.
Anyone know the way to get access to mysql without
password. Or is there a way to change the password?
I get access denied with the Error No. 1044, and 1045.
Thanks
T OPTION;
then restart mysql without the --skip-grant-tables.
thanks,
-- Andrew
-Original Message-
From: Lisa Williams [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 24, 2002 10:59 AM
To: [EMAIL PROTECTED]
Subject: I deleted my root user!
Please help. I accidentally deleted the root
Please help. I accidentally deleted the root user and now I can't do
anything. How can I recreate this user with super user privileges? I'm
new to MySQL so please be detailed.
Thanks in advance
Lisa
-
Befo
> Then I tried to set a password for the MYSQL root user and I get the
> following error.
>
> ./bin/mysqladmin -u root -p password 'christ1'
> Enter password: ***
>
> ./bin/mysqladmin: connect to server at 'localhost' failed
> error: 'Access
/safe_mysqld --user=mysql &
Then I tried to set a password for the MYSQL root user and I get the
following error.
./bin/mysqladmin -u root -p password 'christ1'
Enter password: ***
./bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for
--- 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 securi
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
Hi All,
New to mySql. I've setup ok, running ok, read thru
the privilege system docs. My question is about the
user "root": is it absolutely necessary to keep this
user or is it ok to delete the root user (after
setting up an equivalent "super-user" under ano
Hello All,
I am using Linux, with Apache, mysql among other things.
I am root, user, owner, etc.
Other than getting up there in age, I can't seem to remember the
mysql passwords that I set up for root, users, etc.
is there a way to remove/recover the password I set up for
mysql for roo
]; Rischbode, Horst;
[EMAIL PROTECTED]
Subject: Re[2]: AW: password-recovery for root-user?
>
http://www.mysql.com/documentation/mysql/bychapter/manual_Privilege_system.h
FYI: The link you requested was not found.
Sie schrieben am Mittwoch, 18. Juli 2001, 16:17:24:
>>mysqld --skip-gra
mysql/bychapter/manual_Privilege_system.h
> tml
> -ravi.
> -Original Message-
> From: Andy Tanner [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, July 18, 2001 10:03 AM
> To: Werner Stuerenburg; Rischbode, Horst
> Cc: [EMAIL PROTECTED]
> Subject: RE: AW: password-recove
ode, Horst
Cc: [EMAIL PROTECTED]
Subject: RE: AW: password-recovery for root-user?
Similarly - how about
- take a copy of you original mysql database tables
- overwrite the mysql database tables with the original installation tables
- login as root (the password will be blank)
- import y
Message-
From: Werner Stuerenburg [mailto:[EMAIL PROTECTED]]
Sent: 18 July 2001 13:26
To: Rischbode, Horst
Cc: [EMAIL PROTECTED]
Subject: Re: AW: password-recovery for root-user?
You can reinstall the complete system from scratch, if you are
superuser to that system. Would be the easiest way to
You can reinstall the complete system from scratch, if you are
superuser to that system. Would be the easiest way to do it, I
guess.
> I'm trying to get the root-password to be deleted or set to a
> new value without knowing the old password. (Forgotten...)
table
--
Herzlich
Werner Stuerenburg
Selamat pagi saja.
- Original Message -
From: Rischbode, Horst <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, July 18, 2001 3:23 PM
Subject: AW: password-recovery for root-user?
mit freundlichem Gruss
Horst Rischbode
---
Deutsche Telekom AG Tel: ++49
che Nachricht-
> Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Gesendet am: Mittwoch, 18. Juli 2001 10:18
> An: Rischbode, Horst
> Betreff: Re: password-recovery for root-user?
>
> Your message cannot be posted because it appears to be either spam or
> simply off
On Thursday 10 May 2001 19:38, Peter Pentchev wrote:
> The MySQL root user, the one created as superuser, comes with the username
> 'root' :)
>
> Just start your MySQL server, and try:
>
> mysql -u root
>
> This shall bring you to the MySQL prompt, if you hav
On Thu, May 10, 2001 at 10:16:33AM -0700, Simon Chan wrote:
> In 6.13 of the mysql manual (Setting up th initial Mysql Privileges), it mentions
>that "the Mysql
> root user is created as a superuser who can do anything. The Initial root password
>is empty, so
> anyone
At 10:16 AM -0700 5/10/01, Simon Chan wrote:
>In 6.13 of the mysql manual (Setting up th initial Mysql
>Privileges), it mentions that "the Mysql
>root user is created as a superuser who can do anything. The
>Initial root password is empty, so
>anyone can connect as root w
1 - 100 of 106 matches
Mail list logo
