-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Friday 24 October 2003 02:59, Simon Mushi wrote:

> So, after all this I began creating the root user for mysql with the
> commands specified at the end of the build...they semmed to be accepted by
> the system. Now when I try to do the following, to start using the
> php-nuke database I get the following...no matter what user I try it as:
>
> [EMAIL PROTECTED] sql # mysqladmin create nuke
> mysqladmin: CREATE DATABASE failed; error: 'Access denied for user:
> '@localhost' to database 'nuke''

 'Access denied for user: '@localhost' to database 'nuke

Who @localhost ?

echo "CREATE DATABASE nukel;"|mysql -u root -p

> What am I doing wronf here? Is there a way to reset the mysql
> user/password database, or cansomeon explain to me how the mysql user is
> in anyway related to actual logged in users of the system?

mysql -u root -p

USE mysql;
SELECT * FROM USER;
UPDATE/INSERT blah blah blah;
FLUSH PRIVILEGES;

Or install phpmyadmin, or mysqlcc, or anyone of the, no doubt dozens of, mysql 
GUIs.

- -- 
Mike Williams
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.3 (GNU/Linux)

iD8DBQE/mOUpInuLMrk7bIwRAjz3AKCFwqCf7l2WU4kw2NVDv2gVRPfNrQCgrVCh
ZZY+4aDEEJ/dQk2Wy/YPTK4=
=qndm
-----END PGP SIGNATURE-----

--
[EMAIL PROTECTED] mailing list

Reply via email to