mysqladmin -u root password <new password>
Curtis
sheeri kritzer wrote:
> Hi Alaister,
>
> Your root password is not actually set. If you do
>
> mysql -u root -p<password>
> and it fails, it means that the password is not <password>
>
> if you do
>
> mysql -u root <password>
>
> the mysql client will parse <password> as the database you're trying
> to use -- that's just the syntax of the mysql client. Which means
> that your password is not very secure, because it's the same as your
> database name. You should get an error like this:
>
> ERROR 1049 (42000): Unknown database '<password>'
>
> What you should do is this:
>
> # mysql -u root
>> set password=password("<newpassword>");
>
> where <newpassword> is your new password.
>
> hope this helps.
>
> -Sheeri
>
>
> On 10/27/05, Alastair Roy <[EMAIL PROTECTED]> wrote:
>> Thanks for your reply I think this is the issue I don't think root is
>> allowed to login from local host I created another user called web user
>> and
>> changed the script, that works fine, next question is how do I set the
>> permissions for root in mysql to allow root to login, if I use
>> #mysql -u root <password> I go straight in
>> If I use
>> #mysql -u root -p
>> <password>
>> I get access denied for [EMAIL PROTECTED]
>>
>> -----Original Message-----
>>
>> Visit our websites:
>>
>> http://www.dailysnack.com +IBw-bite size news and gossip+IB0
>>
>> http://www.express.co.uk The Worlds Greatest Newspaper
>>
>> http://www.dailystar.co.uk Simply The Best 7 Days A Week
>>
>> http://www.happymagazine.co.uk The One Stop Shopping Magazine
>>
>> http://www.ok.co.uk First For Celebrity News
>>
>> http://www.northernandshell.co.uk The Mark Of Excellence
>>
>> http://www.expresspictures.com Express Newspapers and OK Magazine
>> online picture archive
>>
>>
>>
>>
>> Also visit:
>>
>> The NMA: Opening Up Newspapers http://www.nmauk.co.uk
>>
>> ###2004###
>> ________________________________________
>> Any views or opinions are solely those of the author
>> and do not necessarily represent those of Express Newspapers
>> ________________________________________
>> The information transmitted is intended only for the person
>> or entity to which it is addressed and may contain confidential
>> and/or privileged material.If you are not the intended recipient
>> of this message please do not read ,copy, use or disclose this
>> communication and notify the sender immediately. It should be
>> noted that any review, retransmission, dissemination or other
>> use of, or taking action in reliance upon, this information by
>> persons or entities other than the intended recipient is prohibited.
>> E-mail communications may be monitored.
>> ****************************************************************************
>>
>> ##EXN2000##
>>
>>
>> From: sheeri kritzer [mailto:[EMAIL PROTECTED]
>> Sent: 25 October 2005 18:06
>> To: Alastair Roy
>> Cc: mysql@lists.mysql.com
>> Subject: Re: PHP and mysql
>>
>> Yes.
>>
>> Whenever you have a problem, go back to basics. Can you login as root
>> on the commandline? What password do you use there? Once you're
>> there, check root's permissions, but I'd be willing to bet your
>> password is incorrect, or root is only allowed to logon from localhost
>> and not the machine the webserver is on.
>>
>> -Sheeri
>>
>> On 10/25/05, Alastair Roy <[EMAIL PROTECTED]> wrote:
>> > Greetings everyone, I am having a problem with PHP and mysql I have
>> copied
>> a
>> > script exactly off a website to open the database and insert a new
>> user I
>> > try to access the mysql database using the root user, and enter
>> information
>> > into the user table, this is the PHP I am using
>> >
>> >
>> >
>> > <?
>> > include 'library/config.php';
>> > include 'library/opendb.php';
>> >
>> > $query = "INSERT INTO user (host, user, password, select_priv,
>> insert_priv,
>> > update_ priv) ".
>> > "VALUES ('localhost', 'phpcake', PASSWORD('mypass'), 'Y',
>> 'Y',
>> > 'Y')";
>> > mysql_query($query) or die('Error, insert query failed');
>> >
>> > $query = "FLUSH PRIVILEGES";
>> > mysql_query($query) or die('Error, insert query failed');
>> >
>> > include 'library/closedb.php';
>> > ?>
>> >
>> >
>> >
>> > When I try this I get the access for user [EMAIL PROTECTED] host denied, it
>> is
>> > driving me nuts no matter what I try I get the same thing other
>> scripts I
>> > have tried do the same thing, have tried messing around with the
>> config.php
>> > and opendb.php included scripts but nothing works if I run php -f
>> opendb.php
>> > I get no errors which I think means it is working, then again I don't
>> know.
>> >
>> >
>> >
>> > Anyone have any ideas ??
>> >
>> >
>> >
>> > Thanks in advance
>> >
>> >
>> > Visit our websites:
>> >
>> > http://www.dailysnack.com +IBw-bite size news and gossip+IB0
>> >
>> > http://www.express.co.uk The Worlds Greatest Newspaper
>> >
>> > http://www.dailystar.co.uk Simply The Best 7 Days A Week
>> >
>> > http://www.happymagazine.co.uk The One Stop Shopping Magazine
>> >
>> > http://www.ok.co.uk First For Celebrity News
>> >
>> > http://www.northernandshell.co.uk The Mark Of Excellence
>> >
>> > http://www.expresspictures.com Express Newspapers and OK Magazine
>> online
>> picture archive
>> >
>> >
>> >
>> >
>> > Also visit:
>> >
>> > The NMA: Opening Up Newspapers http://www.nmauk.co.uk
>> >
>> > ###2004###
>> > ________________________________________
>> > Any views or opinions are solely those of the author
>> > and do not necessarily represent those of Express Newspapers
>> > ________________________________________
>> > The information transmitted is intended only for the person
>> > or entity to which it is addressed and may contain confidential
>> > and/or privileged material.If you are not the intended recipient
>> > of this message please do not read ,copy, use or disclose this
>> > communication and notify the sender immediately. It should be
>> > noted that any review, retransmission, dissemination or other
>> > use of, or taking action in reliance upon, this information by
>> > persons or entities other than the intended recipient is prohibited.
>> > E-mail communications may be monitored.
>> >
>> ****************************************************************************
>> >
>> > ##EXN2000##
>> >
>> >
>> >
>>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
