Avatar of Silas2
Silas2
 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
MySQL Server

Avatar of undefined
Last Comment
Silas2

8/22/2022 - Mon
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

This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23
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

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
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.
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.