asked on

Newbie connect issue

I don't know where to go next. Ubuntu/MySQL 5.1. I need to connect/login from remote dynamic ip pc's.
I edit my.cnf, bind-address= myip, a comment in this file says skip-networking not used by default anymore.
I pull up a mysql> prompt, and run a restart.
I run 'update user set host='*' where user='myname';
but always connection denied

PranjalShah

Look at this MySQL user manual for adding USER to have remote access

http://dev.mysql.com/doc/refman/5.1/en/adding-users.html

From this page,

mysql> CREATE USER 'monty'@'localhost' IDENTIFIED BY 'some_pass';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'localhost'
-> WITH GRANT OPTION;
mysql> CREATE USER 'monty'@'%' IDENTIFIED BY 'some_pass';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'%'
-> WITH GRANT OPTION;

Two of the accounts have a user name of monty and a password of some_pass. Both accounts are superuser accounts with full privileges to do anything. The 'monty'@'localhost' account can be used only when connecting from the local host. The 'monty'@'%' account uses the '%' wildcard for the host part, so it can be used to connect from any host.

Silas2

ASKER

This is getting worse. When I try to connect with the prompt, I always get Access Denied 28000, on the MySQL site, I follow these instructions:
http://dev.mysql.com/doc/refman/5.1/en/resetting-permissions.html
I stop the Mysql service, (check that with grep) restart with --skip-grant-tables, then the instructions say you should always get in, but still Access Denied 28000????

PranjalShah

Try this ..

http://dev.mysql.com/doc/refman/5.1/en/access-denied.html

Silas2

ASKER

Mmmm...this is really tough, still can't connect. I followed everything in that post. I even tried a purge and a reinstall, but I notice that the my.cnf remains the same so I'm not sure if the purge is really getting rid of the old install.
I just keep getting 28000 Access denied, i switch between locahost and the pcs's static IP, I notice the mysqld.sock is empty, I don't know what is supposed to be in this file.
Is there a purge which removes all traces of the previous install?

ASKER CERTIFIED SOLUTION

blue_hunter

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Silas2

ASKER

Sorry, been away.
This problem is really holding my up.
I uninstal, (although I notice this doesn't remove my.cnf and if I delete it, it doesn't come back with a fresh install(??) ) I run another apt-get mysql, still no mysql> prompt, so I can't run any of these flush commands.

Silas2

ASKER

Always the same complaint Er 1045 ( 28000) Access Denied.