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

[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;
+---+
| Database  |
++
| information_schema |
| mysql |
| test|
++


Than restore my backup finally no any error.

thank for all you,  for your  help , time...

regards

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

[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-client-5.0.51a  is running now

what can i do

regards

mysql.sock deleted

[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)

[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 password or without password.

Now neither new passwd nor old passwd also empty passwd is not acceped

I change my mind and I tried that procedure

shell kill `cat /var/db/host_name.pid`

shell mysqld_safe --skip-grant-tables 

shell mysqladmin -u root flush-privileges password newpwd

mysqladmin:connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (2)'

Check that mysql is running and that the socket:'/tmp/mysql.sock' exits!

3rd way is

shell/usr/local/etc/rc.d/mysql-server.sh stop

then

shellsafe_mysqld --user=root --pid-file=/var/db/mysql/mysql.pid
--skip-grand-tables 
[1] 28712
shell Starting mysql deamon with databses from /var/db/mysql
050303 21:04:02 mysql ended

So I suppose that it is not initialize MySQL deamon  isnt it???

How I can recover mysql password?!??

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

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

[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 password or without password.





Now neither new passwd nor old passwd also empty passwd is not acceped


I change my mind and I tried that procedure

shell kill `cat /var/db/host_name.pid`

shell mysqld_safe --skip-grant-tables 

shell mysqladmin -u root flush-privileges password newpwd


mysqladmin:connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (2)'

Check that mysql is running and that the socket:'/tmp/mysql.sock' exits!


3rd way is

shell/usr/local/etc/rc.d/mysql-server.sh stop

then

shellsafe_mysqld --user=root --pid-file=/var/db/mysql/mysql.pid
--skip-grand-tables 
[1] 28712
shell Starting mysql deamon with databses from /var/db/mysql
050303 21:04:02 mysql ended


So I suppose that it is not initialize MySQL deamon  isnt it???


How I can recover mysql password?!??

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]