Re: ERROR 1050 ( ) at line : Table 'columns_priv' already exists

2008-08-25 Thread Deniss Hennesy
All Dear friends İ am mentioning that 2 different server one is running on mysql 4.1 (Current) (dumped) the other is 5.1..xxx (New) (restored) İ solved my problem in such a way that i droped in my new server mysql and test databases mysql show databases;

ERROR 1050 ( ) at line : Table 'columns_priv' already exists

2008-08-22 Thread Deniss Hennesy
Hi to list i ve installed new server. while i was restoring my backup to this server. i took this error and restoring procees is to stop. *ERROR 1050 ( ) at line : Table 'columns_priv' already exists* My old server mysql version is mysql-client-4.0.20 is running on old server but

mysql.sock deleted

2006-07-20 Thread Deniss Hennesy
Hi All While I am doing portupgrade -vr mysql on freebsd server than mysql socket/tmp/mysql.sock is invisible on, so mysql cant be start How I can create mysql socket. How I can start mysql thanks

ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)

2005-03-03 Thread Deniss Hennesy
Hi, I have had to change mysql root passwd My procedure is just below shell mysql -u root -p mysql UPDATE mysql.user SET Password=PASSWORD('newpwd') WHERE User='root'; mysql flush privileges; and I checked this password another consol I saw MySQL wasn't accepted new passwd else, it didnt old

ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)

2005-03-03 Thread Deniss Hennesy
Hi, I have had to change mysql root passwd My procedure is just below shell mysql -u root -p mysql UPDATE mysql.user SET Password=PASSWORD('newpwd') WHERE User='root'; mysql flush privileges; and I checked this password another consol I saw MySQL wasn't accepted new passwd else, it