thanks in advice
I already did something like that ...... the problem was i erase all the
content of the mysql directory and i creaste a new mysql database, and when
i try to restar the mysql daemon (/etc/rc.d/init.d/mysql start) i get a
message like:
[root@halley mysql]# Starting mysqld daemon with databases from
/var/lib/mysql
010220 03:41:49 mysqld ended
I checked the error file and it looks like:
010220 03:38:03 mysqld started
010220 3:38:04 /usr/sbin/mysqld: Can't find file: './mysql/host.frm'
(errno: 13)
010220 03:38:04 mysqld ended
The matter is that the ¨host.frm' it was created , so i don´t know why
the mysqld is not started.
thanks in advice
===========================================================
Diego Mauricio López G .
Docente Departamento de Conmutación
(Ingeniería Telemática)
Facultad de Ing. Electrónica - Universidad del Cauca. Popayán- Colombia
Tel: (+57-28) 233031 ext 192 Fax: (+57-28) 233031
website: http://www.ucauca.edu.co/~dmlopez
e-mail: [EMAIL PROTECTED]
[EMAIL PROTECTED]
==========================================================
----- Original Message -----
From: Mohamad Ilhami <[EMAIL PROTECTED]>
To: diego López <[EMAIL PROTECTED]>
Cc: mysql list <[EMAIL PROTECTED]>
Sent: Monday, February 19, 2001 10:48 PM
Subject: Re: Help with access denied
> On Mon, 19 Feb 2001, [iso-8859-1] diego López wrote:
>
> > Hi all,
> > i installed successful Mysql ver 3.25.33-1
> > after that i changer the root password and when i make a connection
looks
> > like i am connecting with the user @localhost instead the root user
> >
> > [root@halley bin]# mysql -u root mysql
> > ERROR 1044: Access denied for user: '@localhost' to database 'mysql'
> >
> > I have tried running mysql_install_db but it does´n not actualice the
> > tables
> > i have tried change the root password but i am not aloud to do that. i
get
> > a message like:
> you should rename database mysql to another database first
> /etc/rc.d/init.d/mysql stop
> mv /var/lib/mysql/mysql /var/lib/mysql/mysql_old
> mysql_install_db
> /etc/rd.d/init.d/mysql start
>
> now root password is blank.
> >
> >
> > [root@halley dmlopez]# /usr/bin/mysqladmin -u root -p password
> > 'new-password'
> > Enter password:
> > /usr/bin/mysqladmin: connect to server at 'localhost' failed
> > error: 'Access denied for user: 'root@localhost' (Using password: YES)'
> forget password or password error?
>
> /usr/bin/safe_mysql --skip-grant-tables
> mysql -u root mysql
>
> enter this query
> update user set password=password('some-password') where user='root';
>
> then restart your mysql server normally.
>
> do not play game with your root password. after change password, run query
> 'FLUSH PRIVILEGES'.
>
> for complete information see the documention.
> --ilham--
> >
> >
> > Any idea how resolve this problem?
> > Thanks in advice
> >
> >
> > ===========================================================
> > Diego Mauricio López G .
> > Docente Departamento de Conmutación
> > (Ingeniería Telemática)
> > Facultad de Ing. Electrónica - Universidad del Cauca. Popayán- Colombia
> > Tel: (+57-28) 233031 ext 192 Fax: (+57-28) 233031
> > website: http://www.ucauca.edu.co/~dmlopez
> > e-mail: [EMAIL PROTECTED]
> > [EMAIL PROTECTED]
> > ==========================================================
> >
> >
> > ---------------------------------------------------------------------
> > Before posting, please check:
> > http://www.mysql.com/manual.php (the manual)
> > http://lists.mysql.com/ (the list archive)
> >
> > To request this thread, e-mail <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> >
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
