Re: MySQL permission

From: Dave Uhring (daveuhring_at_yahoo.com)
Date: 05/26/05 

Date: Wed, 25 May 2005 21:14:00 -0500

On Tue, 24 May 2005 09:19:59 -0700, zeman wrote:

> I'm trying to access my databases, but it's giving:
> Access denied for user: 'root@localhost'
> i can log in to mysql with a login username (i.e. zeman), but not with
> root. Moreoever, if i log in with zeman, I can only see the "test"
> database that comes by default with my Linux.

If you had bothered to read and implement the instructions presented to
you after installing the initial database you would not have this problem.

  echo "PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !"
  echo "This is done with:"
  echo "$bindir/mysqladmin -u root password 'new-password'"
  echo "$bindir/mysqladmin -u root -h $hostname password 'new-password'"
  echo "See the manual for more instructions."

Relevant Pages

  • Re: IF/Else using MySQL results
    ... Jerim79 wrote: ... I need it to do one set of instructions. ... echo "There are $num users with that name in the database"; ...
    (alt.php)
  • Re: [PHP] peer review (was php framework vs just php?)
    ... the database. ... Additional arguements may be supplied to indicate columns to ... echo "<input ... single quotes in the Type column of the ...
    (php.general)
  • Re: Change Password by User
    ... You may also be interested in the Security FAQ, which provides instructions on ... See http://www.QBuilt.com for all your database needs. ... One may open a specific form when the database opens by running code that ...
    (microsoft.public.access.security)
  • Re: [SLE] For or against ..Hyperthreading.
    ... > Let's say for mail or Database server... ... Opteron and Athlon-64 also have a different memory access archetecture so ... - 64-bit Address registers means more memory is directly addressable, ... do a wider range of operations as primitive instructions (for example, fetch, ...
    (SuSE)
  • Re: [PHP] peer review (was php framework vs just php?)
    ... function formCreate($database, $table, $action, $excludeCols, ... the database. ... Additional arguements may be supplied to indicate columns to ... echo "<input ...
    (php.general)