[BlueOnyx:04271] Re: MySQL/phpmyadmin error

[Don Teague]

For the record .. I can connect the mysql via command line using the
'root' user, and the user of other databases. (Always with the
password command, of course.)

Everything is up, I just can't access phpmyadmin from the admin
interface/GUI .. and the mysql connection section shows no
connection...

Command line has always worked though...

On Sat, Apr 17, 2010 at 5:35 PM, Don Teague <blueonyx at donteague.com> wrote:
> Failed.
>
> [root at bx2 ~]# mysql -u root -p
> Enter password:
> Welcome to the MySQL monitor.  Commands end with ; or \g.
> Your MySQL connection id is 746
> Server version: 5.0.77 Source distribution
>
> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
>
> mysql> update user set Password=PASSWORD('newpassword') where User='root';
> ERROR 1046 (3D000): No database selected
> mysql> quit
>
>
> On Sat, Apr 17, 2010 at 5:04 PM, Gerald Waugh <gwaugh at raqware.com> wrote:
>>
>> On Sat, 2010-04-17 at 16:31 -0500, Don Teague wrote:
>>> Anyone else have ideas? (Or tell me where the file is, that would be a
>>> start.....)
>>
>> Looks like you get into mysql
>> When there.....
>>
>> mysql> update user set Password=PASSWORD('newpwd') where User='root';
>> mysql> quit
>>
>> Then go into the network services msyql
>> and set the same password
>>
>> Gerald
>>
>> _______________________________________________
>> Blueonyx mailing list
>> Blueonyx at blueonyx.it
>> http://www.blueonyx.it/mailman/listinfo/blueonyx
>>
>>
>