On Thu, Oct 13, 2005 at 01:06:21PM +0300, Alex wrote:
> Date: Thu, 13 Oct 2005 13:06:21 +0300
> From: Alex <[EMAIL PROTECTED]>
> Subject: [rlug] mysql fara parola
> To: [email protected]
>
> Hello all,
>
> Am un mysql (Ver 14.7 Distrib 4.1.12) caruia i-am setat parola pentru
> [EMAIL PROTECTED] Userii mei din lan au scris scripturile cu picioarele, asa
> ca
> TREBUIE sa ma intorc inapoi la conectarea FARA PAROLA la baza de date.
Altfel, pe langa sfaturile celorlalti, ai putea sa iei in considerare
faptul ca NU e tocmai smart sa lasi superuser privs pentru altcineva in
afara de tine. Ai posibilitatea sa grant all privileges on blackhole.*
to expertiza..........
>
> Am incercat:
> use mysql;
> SET PASSWORD FOR [EMAIL PROTECTED]('');
> flush privileges;
>
> dupa chestia asta:
> [EMAIL PROTECTED] root]# mysql
> ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
> password:
> YES)
> [EMAIL PROTECTED] root]#
>
> Deci nu ma lassa.... Daca dau mysql -p si la parola apasa ENTER, atunci se
> conecteaza.
> [EMAIL PROTECTED] root]# mysql -p
> Enter password:
> Welcome to the MySQL monitor. Commands end with ; or \g.
> Your MySQL connection id is 30 to server version: 4.1.12-Max-log
>
> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
>
> mysql>
>
> Deci cum ii dau sa nu mai ceara parola pemtru root?
>
> Iata mai jos ce am acum setat la root:
> mysql> select host, user, password from user where user="root";
> +-----------+------+----------+
> | host | user | password |
> +-----------+------+----------+
> | localhost | root | |
> +-----------+------+----------+
> 1 row in set (0.00 sec)
>
> Alex
>
> _______________________________________________
> RLUG mailing list
> [email protected]
> http://lists.lug.ro/mailman/listinfo/rlug
>
>
> --
> This message was scanned for spam and viruses by BitDefender.
> For more information please visit http://www.bitdefender.com/
>
--
This message was scanned for spam and viruses by BitDefender.
For more information please visit http://www.bitdefender.com/
_______________________________________________
RLUG mailing list
[email protected]
http://lists.lug.ro/mailman/listinfo/rlug
