Hello Érico,
On 5/29/2014 3:51 PM, Érico wrote:
I am really sorry about this one ..
the connection is ok ...
I had not checked that I was using mysqladmin instead of mysql
now please how can I check what is wrong with my application ( My SQL Admin
)
at its login page it asks for user / pwd /
I am really sorry about this one ..
the connection is ok ...
I had not checked that I was using mysqladmin instead of mysql
now please how can I check what is wrong with my application ( My SQL Admin
)
at its login page it asks for user / pwd / server and db
using both localhost and 127.0.01 .
Hello Érico
On 5/29/2014 2:22 PM, Érico wrote:
I have ran the following to test a fix for an app issue :
delete from mysql.user where user='';
2lines got effected
after this I can´t connect through command line anymore :
./mysqladmin -u root password
I get access denied for user 'root'@'loc
well, i am mysql administrator over 10 years now
and never needed the "mysqladmin" command because
the mysql command line client offers anything i
ever needed
mysql -u root -p
[harry@srv-rhsoft:~]$ mysql -u root -p
Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your M
running this :
./mysqladmin -u root -p
at this momento it thorws me to mysqladmin man page
2014-05-29 15:35 GMT-03:00 Reindl Harald :
>
> Am 29.05.2014 20:22, schrieb Érico:
> > I have ran the following to test a fix for an app issue :
> >
> > delete from mysql.user where user='';
> > 2lines
Hi
thanks but it is not working either
I wonder if the 2 rows I removed (with empty users for localhost and my
computer names) were responsilbe for allowing the autentication ?
how this table works ?
what mysql checks on it ? the pwd column ? if it is filled ?
what if I have 2 records for root
Did you tried this..
http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html
*thanks,*
*-- *Kishore Kumar Vaishnav
On Thu, May 29, 2014 at 11:22 AM, Érico wrote:
> I have ran the following to test a fix for an app issue :
>
> delete from mysql.user where user='';
> 2lines got effecte
Am 29.05.2014 20:22, schrieb Érico:
> I have ran the following to test a fix for an app issue :
>
> delete from mysql.user where user='';
> 2lines got effected
>
> after this I can´t connect through command line anymore :
>
> ./mysqladmin -u root password
>
> I get access denied for user 'roo
ok
I have tried these :
ifconfig -a
lo0: flags=8049 mtu 16384
inet6 ::1 prefixlen 128
inet6 fe80::1%lo0 prefixlen 64 scopeid 0x1
inet 127.0.0.1 netmask 0xff00
gif0: flags=8010 mtu 1280
stf0: flags=0<> mtu 1280
fw0: flags=8863 mtu 4078
lladdr 70:cd:60:ff:fe:eb:72:ea
media:
Hi
> > > | | ericomtxmacbookpro.local |
> > *E85DC00A0137C6171923BE35EDD809573FB3AB4F |
> > >
>
mysql> DELETE FROM mysql.user WHERE user='';
mysql> FLUSH PRIVILEGES;
maybe helps?
Cheers
--
Claudio
yes it is ...
also , the eclipse is also local ...
in both ... mysql-admin php application , plus inside eclispe plugin ...
same behavior in both
2014/1/13 Reindl Harald
> i doubt that the webserver is running on the same
> machine as your mysql command shell
>
> Am 13.01.2014 23:59,
Am 13.01.2014 21:47, schrieb shawn l.green:
> Hello Reindl,
> We are not saying he is using HTTP commands to log into his database
we excludes obviously the OP or his overall understanding :-)
Am 13.01.2014 18:54, schrieb Érico:
> using both urls I get the same error :
>
> http://localhost/mysql
fer-Encoding: quoted-printable
Please provide the output of the below query.
Select user, host, password from mysql.user;
Thanks
Vikas Shukla
Mail Sent from my Windows Phone From: Reindl Harald
Sent: =E2=80=8E14-=E2=80=8E01-=E2=80=8E2014 01:38
To: mysql@lists.mysql.com
Subject: Re: Access den
Hello Reindl,
On 1/13/2014 3:01 PM, Reindl Harald wrote:
*your application* is connecting to mysql
*your application* is using a hostname
*your application* *may* use 127.0.0.1
*your application* should use localhost to *connect to the databse*
*your application* can only use TCP *if there is* a
*your application* is connecting to mysql
*your application* is using a hostname
*your application* *may* use 127.0.0.1
*your application* should use localhost to *connect to the databse*
*your application* can only use TCP *if there is* a *mysql user* with *that
host*
http://dev.mysql.com/doc/re
WTF - we are talking about *database connections* and *not* http-URL's
the webserver is only the *messenger*
Am 13.01.2014 18:54, schrieb Érico:
> using both urls I get the same error :
>
> http://localhost/mysql/index.php
> http://127.0.0.1/mysql/index.php
>
> in 127.0.0.1... after I submit the
Hi
no connections outside command line are being accepted . I have connected
through command line , but not using eclipse for example ... it gets the
same error from the web app
my apache and pages are in the same computer that mysql
I am not getting password issues.. otherwise I would not conne
Hello Érico,
On 1/13/2014 1:49 PM, Érico wrote:
Hi
didn't work
look ... isn't this something related to this :
are you using "localhost" or "127.0.0.1" in the web-application
root@localhost != root@127.0.0.1 = different users
localhost: Unix-Socket
127.0.0.1: TCP
...
since I am not able to
Hi
didn't work
look ... isn't this something related to this :
are you using "localhost" or "127.0.0.1" in the web-application
root@localhost != root@127.0.0.1 = different users
localhost: Unix-Socket
127.0.0.1: TCP
...
since I am not able to stabilsh a connection even with using eclipse ...
On 13 January 2014 13:25, Érico wrote:
> the granting is not affecting the tables:
>
> mysql> grant all privileges on *.* to root@localhost identified by 'pwd';
> Query OK, 0 rows affected (0.00 sec)
>
> mysql> FLUSH PRIVILEGES;
> Query OK, 0 rows affected (0.00 sec)
>
> ...
>
> and if I try the g
the granting is not affecting the tables:
mysql> grant all privileges on *.* to root@localhost identified by 'pwd';
Query OK, 0 rows affected (0.00 sec)
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)
...
and if I try the granting in 127.0.0.1 :
mysql> grant all privileges to *.*
I forgot this. Do it too.
On 13 January 2014 13:01, Erick Ocrospoma wrote:
> I presume your index.php file uses "127.0.0.1". After login to MySQL try this:
>
> $> grant all privileges to *.* 'root'@'127.0.0.1' identified by
> ;
$> flush privileges;
>
> Of course this could not be the best soluti
I presume your index.php file uses "127.0.0.1". After login to MySQL try this:
$> grant all privileges to *.* 'root'@'127.0.0.1' identified by ;
Of course this could not be the best solution, it's just to skip it,
you must look at the query/connection on your php file.
On 13 January 2014 12:57,
using localhost the coonection works ...
ericomtxmacbookpro:bin ericomtx$ ./mysql -u root -p mysql-admin -h
localhost -P 3306
Enter password:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MySQL monit
using both urls I get the same error :
http://localhost/mysql/index.php
http://127.0.0.1/mysql/index.php
in 127.0.0.1... after I submit the index.php ... it redirects to localhost
too ..
2014/1/13 Reindl Harald
>
>
> Am 13.01.2014 18:28, schrieb Érico:
> > ericomtxmacbookpro:bin ericomtx$ ./m
>From that error I would suspect you are trying to access to a database
where has not external access. And yeah, try by doing
$> mysql -u root -p -h localhost -P 3306
change localhost by 127.0.0.1 in order to test if both cases work, and
see which of them (localhost/127.0.0.1) is defined in your
Am 13.01.2014 18:28, schrieb Érico:
> ericomtxmacbookpro:bin ericomtx$ ./mysql -u root -p mysql-admin
> Enter password:
> Welcome to the MySQL monitor. Commands end with ; or \g.
> Your MySQL connection id is 31
> Server version: 5.6.15 MySQL Community Server (GPL)>
>
> but in the browser I get
You mysql.user table might be corrupted.
If you have access to it as a root user, try check table mysql.user, and
repair table mysql.user if table corruption was detected.
Alternatively, shut down mysql server, cd /var/lib/mysql/mysql (to your
$datadir/mysql directory) and run
mysqlcheck -r mys
Hi,
>¶¼ÊÇÖйúÈ˾Í˵ÖÐÎÄ°É^_^
Nice to meet you. But I think that this newsgroup is for the people who come
from all of the world. So post topics in English is better for anyone who is
also interested about this topic, right?
>Ã÷Ìì»á¸üºÃ
I like this sentence. Õæ¸ßÐËÄÜÔÚÕâÀï¼ûµ½×Ô¼ºÈË¡£Ï£ÍûÒÔºóÄ
太搞笑了,哈哈
2010/9/25 Neo
> 都是中国人就说中文吧^_^
>
>
> 明天会更好
>
>
> On Sat, Sep 25, 2010 at 9:21 AM, Ma Xiaoming >wrote:
>
> > Hi Shawn,
> >
> > > You forgot to use -- before the option "version". Try this instead
> > >
> > > mysqladmin --version
> > >
> > > Let us know your results.
> >
> > Oh yes, it
都是中国人就说中文吧^_^
明天会更好
On Sat, Sep 25, 2010 at 9:21 AM, Ma Xiaoming wrote:
> Hi Shawn,
>
> > You forgot to use -- before the option "version". Try this instead
> >
> > mysqladmin --version
> >
> > Let us know your results.
>
> Oh yes, it works. When I typed the right command: mysqladmin --versio
Hi Shawn,
> You forgot to use -- before the option "version". Try this instead
>
> mysqladmin --version
>
> Let us know your results.
Oh yes, it works. When I typed the right command: mysqladmin --version
I got the following result: mysqladmin Ver 8.42 Distrib 5.1.50, for Win32 on
ia32
Many t
On 9/24/2010 4:11 AM, Ma Xiaoming wrote:
Dear all,
I have installed the MySQL version 5.1.50 with complete installation. After
the installation process is finished and the configuration is done, when I
run 'mysqladmin' with option 'version' in prompt, I got the following error
message:
Hi,
> As the console print,do you enter the password for user "ODBC" correctly?
How to correctly use this console application, that is how to pass password
when calling this console application? Thanks.
> ODBCÓû§ÃÜÂë²»¶Ô£¬ËµµÄºÜÃ÷ÏÔ.
ÎÒÊÇÐÂÊÖ£¬»¹²»»áʹÓÃMySQL¡£ÇëÎÊÈçºÎÔÚÔËÐÐmysqladminÕâ¸öÃüÁ
On 2010年09月24日 16:11, Ma Xiaoming wrote:
Dear all,
I have installed the MySQL version 5.1.50 with complete installation. After
the installation process is finished and the configuration is done, when I
run 'mysqladmin' with option 'version' in prompt, I got the following error
message:
In the last episode (Sep 20), Pete Wilson said:
> I'm pretty new to MySql, but not many years ago I was an ISAM guy so I
> understand the issues with indexes and on-the-fly inserts.
>
> I've seen many questions around this error message, "Access denied; you
> need the RELOAD privilege for this ope
nks,
Jesse
- Original Message -
From: Jim Lyons
To: Jesse
Cc: MySQL List
Sent: Friday, October 10, 2008 8:28 AM
Subject: Re: "access denied" error
What is the PHP connect string? Are you connecting to the database you have
access to? are you connecting as t
What is the PHP connect string? Are you connecting to the database you have
access to? are you connecting as the same user (myuser)? Do other php
applications work, so you know it's not a php-mysql issue?
On Fri, Oct 10, 2008 at 6:59 AM, Jesse <[EMAIL PROTECTED]> wrote:
> I have a PHP applicati
That was it. Once I removed PASSWORD, it went through, and I'm able to restart
MySQL now.
Thanks for your help.
Jesse
- Original Message -
From: Ian Simpson
To: Jesse
Cc: MySQL List
Sent: Tuesday, July 22, 2008 4:48 AM
Subject: Re: Access denied for user '
Hi Jesse,
If you're specifying the password in plain text, you shouldn't put the
PASSWORD directive in there; you only use PASSWORD if you're using the
hashed password that MySQL will actually store.
GRANT ALL PRIVILEGES ON *.* TO 'debian-sys-maint'@'localhost' IDENTIFIED
BY 'LongPasswordHere' W
Do you login via sock or network ?
Didja change the passwd for localhost and % ?
--Original Message--
From: Jesse
To: MySQL List
Sent: Jul 21, 2008 17:35
Subject: Access denied for user 'debian-sys-maint'@'localhost'
OK. This is driving me Nutz 8-p
Any time I try to restart mysql, I get
With assistance from a friend this issue has been rectified.
The current GRANT was not sufficient. After executing the new GRANT
with 'ALL PRIVILEGES' (using the --init-file switch) the root user can
now issue GRANTS.
Additionally I apologise for duplicate posts, It was not intentional.
On 9/2/0
Car Toper wrote:
> More info...
>
> I am able to login with the account via phpMyAdmin on the server.
> Also, I am trying to use phpMyAdmin to change the permissions, but I
> cannot figure out the syntax:
>
> GRANT ON ppsntracker.* TO [EMAIL PROTECTED] WITH GRANT OPTION;
>
> Cartoper
>
> On 8/21/07
More info...
I am able to login with the account via phpMyAdmin on the server.
Also, I am trying to use phpMyAdmin to change the permissions, but I
cannot figure out the syntax:
GRANT ON ppsntracker.* TO [EMAIL PROTECTED] WITH GRANT OPTION;
Cartoper
On 8/21/07, Car Toper <[EMAIL PROTECTED]> wro
2007 4:36:33 PM (GMT-0500) America/New_York
Subject: Re: Access Denied When Trying to Create Database
Gerald,
I tried this and it still didn't work!
Raven:~ untz$ mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 223 to server
Don't you mean this ?
grant all privileges on *.* to 'untz'@'localhost' identified by 'maddog';
- Original Message -
From: "untz" <[EMAIL PROTECTED]>
Cc: mysql@lists.mysql.com
Sent: Monday, June 11, 2007 4:36:33 PM (GMT-0500) America
Gerald,
I tried this and it still didn't work!
Raven:~ untz$ mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 223 to server version: 5.0.16-standard
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> grant
untz wrote:
Gerald,
I tried this and still got an error!
mysql> grant all privileges on *.* to 'untz'@'localhost' identified by
'maddog';
ERROR 1045 (28000): Access denied for user 'untz'@'localhost' (using
password: YES)
mysql>
Can anyone please help me? I am unable to use MySQL at all,
T statement you
used
Should be "grant super privileges on *.* to 'untz'@'localhost'
identified by 'password';
Not "grant super *.* to 'untz'@'localhost' identified by 'password';"
Regards,
Mikhail Berman
-Original Me
Gerald,
I tried this and still got an error!
mysql> grant all privileges on *.* to 'untz'@'localhost' identified
by 'maddog';
ERROR 1045 (28000): Access denied for user 'untz'@'localhost' (using
password: YES)
mysql>
Can anyone please help me? I am unable to use MySQL at all, at this
po
#x27;password';"
Regards,
Mikhail Berman
-Original Message-
From: untz [mailto:[EMAIL PROTECTED]
Sent: Monday, June 11, 2007 4:02 PM
To: Ananda Kumar
Cc: mysql@lists.mysql.com
Subject: Re: Access Denied When Trying to Create Database
Ananda,
Thank you for responding!
untz wrote:
Ananda,
Thank you for responding!
I just tried this and got the following:
mysql> grant super *.* to 'untz'@'localhost' identified by 'password';
ERROR 1064 (42000): You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right
Ananda,
Thank you for responding!
I just tried this and got the following:
mysql> grant super *.* to 'untz'@'localhost' identified by 'password';
ERROR 1064 (42000): You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right
syntax to
Hi,
I think you need to log in as root and grant yourself some privileges then. If you
have lost the root password or root doesn't have privileges anymore either, there is a
chapter in the manual on how to do this: http://dev.mysql.com/
Cheers
Baron
untz wrote:
Baron & Prathima,
Thank for
Is this a user "untz" going to do even the "create procedure", if yes then
you need to grant "super" previliege to this user.
grant super on *.* to 'untz'@'localhost' identified by 'password';
regards
anandkl
On 6/11/07, untz <[EMAIL PROTECTED]> wrote:
Baron & Prathima,
Thank for the informa
Baron & Prathima,
Thank for the information!
What happened is that I hadn't used MySQL for a long time and looked
up on the Internet on how to change my root and individual users'
passwords.
The last command the URL had me type was "flush privileges;" and once
I did that, I think it crea
Hi untz,
untz wrote:
Hello there,
I am using MySQL 5 on OS X Tiger...
After starting the server, I tried to create a sample database and this
is what what happened:
$ mysql -u untz -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 4 to
Kaushal Shriyan schrieb:
Hi ALL
I am faced with a issue of creating database , The issue is I am able
to enter to the MySQL Server with the password, but when i try to
create database I get Access Denied
Below are the details
[EMAIL PROTECTED] root]# mysql -u root -p
Enter password:
Welcome to
On 6/9/06, Dilipkumar <[EMAIL PROTECTED]> wrote:
Hi,
Please check the data directory where u have started your mysql has
permission ( mysql:mysql )
U would have started your ur mysql ar root user and when u create a
database which has
no permission as (mysql) in data directory.
This might help
Hi,
Please check the data directory where u have started your mysql has
permission ( mysql:mysql )
U would have started your ur mysql ar root user and when u create a
database which has
no permission as (mysql) in data directory.
This might help you out.
Kaushal Shriyan wrote:
Hi ALL
I am
Hello.
Are you able to connect to MySQL Server if you blank the root password?
Use mysql command line client from 5.0 distribution. Have you run
mysql_fix_privilege_tables script? Please, provide the CREATE statement
for mysql.user table.See:
http://dev.mysql.com/doc/refman/5.0/en/access-denied.
hi ,
see -skip-grant-tables in dev.mysql.com/doc
Mathias
Selon Seena Blace <[EMAIL PROTECTED]>:
> Is there any way I can change passwd of database without knowing the
> administrator .
> I'm unable to get into the mysql prompt due to access denied message.I want
> to change passwd.How to do this
Is there any way I can change passwd of database without knowing the
administrator .
I'm unable to get into the mysql prompt due to access denied message.I want to
change passwd.How to do this? After change passwd do you think we need to grant
some priviledges?
thanks
Anoop kumar V <[EMAIL PRO
The reason i sthat you have not provided authorisation privileges to the
database or to the tables within the database for that user...
Very often we think granting all to the database is enough to make our app
work with a particular user - this may be true for some databases - but in
mysql you
Hello.
See:
http://dev.mysql.com/doc/mysql/en/access-denied.html
http://dev.mysql.com/doc/mysql/en/resetting-permissions.html
Seena Blace <[EMAIL PROTECTED]> wrote:
> [-- text/plain, encoding 8bit, charset: iso-8859-1, 17 lines --]
>
> Hi,
>
> I have been noticing followi
Hello.
> Could be that the connect command fails, then I start trying and trying,
> and then the server blocks because it receives too many connections? Then
> the error message would be the one that I'm getting?
I also thought about this and therefore I gave you that advice. What
i
the error message would be the one that I'm getting?
Thanx in advance,
Jorge
From: Gleb Paharenko <[EMAIL PROTECTED]>
To: mysql@lists.mysql.com
Subject: Re: Access denied for user: '[EMAIL PROTECTED]' (Using password:
NO)
Date: Mon, 18 Apr 2005 18:38:54 +0300
Hello.
It is str
Hello.
It is strange that refusing message says you're not using passwords.
Does the problem disappear after the "FLUSH HOSTS" statement, instead of
restarting MySQL server?
"Jorge Cambra Aused" <[EMAIL PROTECTED]> wrote:
>
> I have a web application running with Apache with PHP 4
Hello.
Using the general-log you could find if something
changes the grant tables. See:
http://dev.mysql.com/doc/mysql/en/query-log.html
Also I strongly recommend you to upgrade to the latest
release, if you don't use it already.
>so whats the final solution to my problem ? :( >
Hello.
Right. No need to FLUSH PRIVILEGES after GRANT.
My fault, sorry.
Michael Stassen <[EMAIL PROTECTED]> wrote:
>
> Gleb Paharenko wrote:
>> Hello.
>>
>> Execute FLUSH PRIVILEGES after granting.
>> See:
>> http://dev.mysql.com/doc/mysql/en/flush.html
>> http://dev.mysq
Gleb Paharenko wrote:
Hello.
Execute FLUSH PRIVILEGES after granting.
See:
http://dev.mysql.com/doc/mysql/en/flush.html
http://dev.mysql.com/doc/mysql/en/privilege-changes.html
Yes, please read this one. FLUSH PRIVILEGES is NOT needed after GRANT,
REVOKE, or SET PASSWORD. You only need to FL
Hello.
Execute FLUSH PRIVILEGES after granting.
See:
http://dev.mysql.com/doc/mysql/en/flush.html
http://dev.mysql.com/doc/mysql/en/privilege-changes.html
http://dev.mysql.com/doc/mysql/en/access-denied.html
http://dev.mysql.com/doc/mysql/en/user-resources.html
Connect to the ser
Hello.
Are you doing FLUSH PRIVILEGES after granting?
Metal Host Contact <[EMAIL PROTECTED]> wrote:
> I have installed in a single user called "metal-host"
> more than 10 databases all with different names
> and in different php scripts (phpbb phpnuke mambo etc).
> the problem is th
Hello.
I successufully connected to MySQL server using your parameters
in odbc.ini and odbcinst.ini files from php.
> [unixODBC][MySQL][ODBC 3.51 Driver]Access denied for user:
> '[EMAIL PROTECTED]' (Using password: NO)
You have specified the user and the password in the ODBC configurat
' . mysql_error() .
'');
}
}
HTH
Peter
> -Original Message-
> From: Christian Biggins [mailto:[EMAIL PROTECTED]
> Sent: 26 January 2005 13:30
> To: 'Peter Lovatt'; mysql@lists.mysql.com
> Subject: RE: Access denied f
Subject: RE: Access denied for user - I cant work this out
Hi Peter,
There is a password being suppled - see code (btw, its local testing only,
hence the root user)
//Database Settings
$db_host = 'localhost'; //database hostname $db_name =
'powerpla_powerplay'; //dat
}
}
-Original Message-
From: Peter Lovatt [mailto:[EMAIL PROTECTED]
Sent: Thursday, 27 January 2005 12:27 AM
To: Christian Biggins; mysql@lists.mysql.com
Subject: RE: Access denied for user - I cant work this out
hi
you are not passing a password to my
hi
you are not passing a password to mysql - check your code to see if this is
correct.
Peter
> -Original Message-
> From: Christian Biggins [mailto:[EMAIL PROTECTED]
> Sent: 26 January 2005 12:27
> To: mysql@lists.mysql.com
> Subject: Access denied for user - I cant work this out
>
>
>
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
[EMAIL PROTECTED] wrote:
> I didn't get a response to the question below, and my alternative solution
> produced another error message as follows. Rather than try to establish a
> new database, I used the Test database established when I reinstalled
> mysql. With a csv file saved under mys
On Thursday 01 July 2004 09:08 am, Nguyen, Long P (Mission Systems) wrote:
> shouldn't I be able to issue commands at the shell it goes and does it
> thing and give back output? or does this mean I have a passwd already set
> and it's secured?
>
http://dev.mysql.com/doc/mysql/en/User_Account_Mana
en, Long P (Mission Systems)
Cc: [EMAIL PROTECTED]
Subject: Re: Access denied for user: '[EMAIL PROTECTED]' (Using password:
NO)
Re-installing does not get rid of your old passwords.
You need to use the -p option.
Nguyen, Long P (Mission Systems) wrote:
>Hi -
>
>I am new
Re-installing does not get rid of your old passwords.
You need to use the -p option.
Nguyen, Long P (Mission Systems) wrote:
Hi -
I am new to MySQL - I just recently re-installed MySQL by rpm and when ever I try to issue
a command from the shell prompt, such as mysqladmin or mysqlshow, I would ge
"Phil Ewington - 43 Plc" <[EMAIL PROTECTED]> wrote:
> Hi All,
>
> I have just installed mysql-4.0.18 on my cobalt RaQ4 and for the first time
> seemed to actually got somewhere! however, my existing PHP scripts failed to
> connect to localhost as the password has not been set after the install. I
"Jan Broermann" <[EMAIL PROTECTED]> wrote:
> Hi, I've got a little Excel Macro that connects to
> MySQL via ADO below is the code. Funny thing is
> it connects to the database and executes the truncate
> orders without a problem.
>
> But when I come to Load data in file i receive an
> [MySQl][ODBC
On 15 Mar 2004, at 15:35, Victoria Reznichenko wrote:
Probably you specified wrong password in the option file on
'bc-1-1-02' box.
Check the output of mysql --print-defaults.
Nice idea, but no - I typed the password in manually both times, and I
have repeated the experiment several times (and so
Tim Cutts <[EMAIL PROTECTED]> wrote:
>
> Server version: MySQL 4.0.18, running on Red Hat Linux 8.0
>
> Symptoms: All our machines except for one can connect to the database.
> That one machine gets 'access denied'.
>
> All users are affected, even root.
>
> SHOW GRANTS for an example user:
TECTED]>
> To: "KKoTY" <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>
> Sent: Friday, February 06, 2004 6:21 AM
> Subject: Re: Access denied for user: '[EMAIL PROTECTED]' (Using password:
YES)
>
>
> > I have installed MyODBC 3.51 and created
[EMAIL PROTECTED]>
Sent: Friday, February 06, 2004 6:21 AM
Subject: Re: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)
> I have installed MyODBC 3.51 and created the DSN for my Database.
>
> I want to clarify that;
> If the User name I have given is could
I have installed MyODBC 3.51 and created the DSN for my Database.
I want to clarify that;
If the User name I have given is could not be resolved by mysal_real_connect,
then it automatically establish the connection to the server using
[EMAIL PROTECTED] - right
If so, Is there need to have the us
this occures when you ommit the user name, MYSQL C API uses user ODBC as
default when you ommit or enter empty string as
user name when calling mysql_real_connect()
- Original Message -
From: "Arunachalam" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, February 05, 2004 3:38 P
Arunachalam wrote:
Hi all,
Is any one met with the error while connecting to MySQL Server
*Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)*
OK, you tried to log into mysql as [EMAIL PROTECTED], using a password.
if so pleass let me know the remedy to resolve this error.
I don
You have attempted to login with out supplying a username. Try logging in
like:
mysql -u -p
>> Original Message <<
On 2/5/04, 8:38:13 AM, Arunachalam <[EMAIL PROTECTED]> wrote regarding
Access denied for user: '[EMAIL PROTECTED]' (Using password: YES):
> Hi all
I get the following access denied error:
Warning: mysql_pconnect(): Access denied for user:
'[EMAIL PROTECTED]' (Using password: YES) in
C:\Apache\Apache2\html\C2R\catalog\includes\functions\database.php on
line 17
Unable to connect to database server!
Why Is this happening and how can I fix it?
"Shane Korosec" <[EMAIL PROTECTED]> wrote:
> I have recently installed MySQL my mac running OS X 10.3 and can connect to
> MySQL using the command:
> /Library/MySQL/bin/mysql
> However, once connected, I have tried to create a database and received the
> error message:
> ERROR 1044: Access denie
You need to connect as a privileged user. You should delete the anonymous
account for security reasons.
-Original Message-
From: Shane Korosec [mailto:[EMAIL PROTECTED]
Sent: Monday, November 17, 2003 1:56 AM
To: [EMAIL PROTECTED]
Subject: Access denied error
I have recently installed My
gt;; <[EMAIL PROTECTED]>
Sent: Friday, October 10, 2003 6:24 AM
Subject: Re: access denied php my admin .
>
> sorry for this late reply rory
>
> i just got back to work ..
>
> i am trying to connect to 192.168.x.y
>
> but the jerk connects to 192.168.xx.xxx
>
this thing ..
:'(
thnx a bill
toby
From: "Rory McKinley" <[EMAIL PROTECTED]>
To: "toby -" <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>
Subject: Re: access denied php my admin .
Date: Thu, 9 Oct 2003 11:47:25 +0200
Hi toby
If I log in to mysql
1 - 100 of 209 matches
Mail list logo