diego López wrote:
>
> 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: dmlopez@stripped
> dmlopez@stripped
> ==========================================================
>
> ----- Original Message -----
> From: Mohamad Ilhami <m196034@stripped>
> To: diego López <dmlopez@stripped>
> Cc: mysql list <mysql@stripped>
> 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
> > >
You recreated the database as root. Mysqld can not read them.
chown -R mysql /usr/local/mysql/var
Use the actual location of your mysql "var" directory.
