Per the MySQL documentation I used the following commands to establish login
both at the local host and remotely.
mysql SET PASSWORD FOR ''@'localhost' = PASSWORD('newpwd');
mysql SET PASSWORD FOR ''@'%' = PASSWORD('newpwd');
When I attempt the following locally from the Command Prompt (with
aspsa wrote:
Per the MySQL documentation I used the following commands to establish login
both at the local host and remotely.
mysql SET PASSWORD FOR ''@'localhost' = PASSWORD('newpwd');
mysql SET PASSWORD FOR ''@'%' = PASSWORD('newpwd');
When I attempt the following locally from the Command
Try
SET PASSWORD FOR 'root'@'localhost' = PASSWORD( 'newpwd' );
SET PASSWORD FOR 'root'@'%' = PASSWORD( 'newpwd' );
There was no username in your SET PASSWORD command.
Wes
On Jul 30, 2004, at 4:38 PM, aspsa wrote:
Per the MySQL documentation I used the following commands to establish
login
both
after you ran your command, did you:
mysql flush privileges;
?
Per the MySQL documentation I used the following commands to establish login
both at the local host and remotely.
mysql SET PASSWORD FOR ''@'localhost' = PASSWORD('newpwd');
mysql SET PASSWORD FOR ''@'%' = PASSWORD('newpwd');
aspsa wrote:
Per the MySQL documentation I used the following commands to establish login
both at the local host and remotely.
mysql SET PASSWORD FOR ''@'localhost' = PASSWORD('newpwd');
mysql SET PASSWORD FOR ''@'%' = PASSWORD('newpwd');
Here, you set the password for the anonymous users,
FLUSH PRIVILEGES is not necessary after SET PASSWORD or GRANT. You only
need to FLUSH PRIVILEGES when you edit the mysql tables directly (INSERT,
UPDATE, DELETE).
Michael
Michael Dykman wrote:
after you ran your command, did you:
mysql flush privileges;
?
Per the MySQL documentation I used the
[EMAIL PROTECTED] doesn't have a password yet. You need to
mysqladmin -u root password newpwd
where newpwd is the password you want for root.
After setting the password for [EMAIL PROTECTED], you can connect with
mysql -u root -p
I'd suggest that [EMAIL PROTECTED] is a bad idea, so
In mysql, a user is a combination of user and hostname. Initially, there
are 2 superusers, [EMAIL PROTECTED] and [EMAIL PROTECTED] They have the same privileges,
but they are different users. [EMAIL PROTECTED] is for connections via unix
socket (from the same machine on which the mysql
Hi, I am trying to create a script that automatically logs in to mysql and
chooses a db then runs a query.
I can login fine when doing it this way:
mysql -u user -p
it then asks for a pass and it works.
but if I try this:
mysql -u user -ppassword dbname
I get an access error.
any
On Fri, Feb 06, 2004 at 05:06:08PM -0600, Chuck Barnett wrote:
Hi, I am trying to create a script that automatically logs in to mysql and
chooses a db then runs a query.
I can login fine when doing it this way:
mysql -u user -p
it then asks for a pass and it works.
but if I try this:
I was wondering if anyone knows of a way to make a mysql server running
on red hat linux authenticate using nt pass through (something like
samba does it) or possibly ldap. I am new to mysql so this may be very
easy to do I just don't know how. It also might be impossible. Just
wondering if
Can you login to mysql from a perl script by passing it an encrypted password..?
Taylor...
Taylor Lewick
Unix System Administrator
Fortis Benefits
816 881 6073
Help Wanted. Seeking Telepath...
You Know where to apply.
12 matches
Mail list logo