I've solved this puzzle myself. The answer was in a book "MySQL" by Paul DuBois which I bought in Barns & Noble.
gwalters could connect from anywhere except localhost. To fix this you need to
remove the anonymous user entry which comes as a default with mysql.
Launch mysql as the root user using the mysql database.
mysql -u root mysql
mysql> delete from user where user="";...
gwalters
Last Activity: Mar 10 '07, 07:44 AM
Joined: Nov 8 '06
Location:
-
using grant help needed
I'm using MySql 4.022 and am having a problem with grant usage running on local host trying to set up users.
I used this command
grant all on acutrack.* to 'gwalters' identified by 'rutan';
I then try to run mysql with the following command
mysql -u gwalters -p=rutan acutrack
or
mysql -u gwalters -prutan acutrack
and then get access denied.
What... -
Broadband specs
I need to install client software on a remote computer(s) which connect via ODBC to a MySql data base that is remote across the country. Can someone advise me on the specs for the internet connection that would give good performance? I've tried the default you get with broadband but the performance is not good at all. -
You can do either of these
mysql > grant all priviledges on mydata.* to username@IP identified by "password";
mysql > grant all priviledges on mydata.* to username identified by "password";
My question is what would be the specs for the internet connection as far as
speed to get the desired performance. I've done the normal broad band connection between SC and Calif and...Leave a comment:
-
I have solved this problem!!!! Glory. Some bug somewhere enabled tracing
on the data sources. I saw this comment on some forum. Getting rid of it solved the problem. I've know idea how it got set on.
Thanks all for taking the time to listen and respondLeave a comment:
-
Thanks, I don't seem to think the data base itself has a problem since all other workstations are running normal. Also if I use mysql directly all queries work quickly as expected. The software uses ODBC conectivity and I'm wondering if there is some problem between them. I've reinstalled version 3.51 but it did not solve the problem.
Could you elaborate on your option 5?...Leave a comment:
-
BTW the're running MySql 4.022 and ODBC 3.51Leave a comment:
-
{SOLVED} Big problem to solve
I have a customer running an accounting package that connects to a MySql data base on a server. 6 workstations connect to the server and run great. Fast and never a problem. However yesterday running the programs on the server directly got so slow that it takes 5 minutes to run a report that takes only 2 seconds on the 6 workstations. It takes 15 seconds to read a single record! This is true for any program that accesses the data base. All other...
No activity results to display
Leave a comment: