Hi All,
Last night I upgraded my MySQL install from 4.0.20 to 4.1.7. All
seemed to go well -- i stopped and removed the 4.0.20 service.
Installed 4.1.7. Then copied my MYD etc files from the data directory
of my 4.0.20 installation to the new installation and can now use the
mysql client to access the data in my dbs and tables.
However, for some reason, all of my PHP scripts have stopped working,
except, for some reason, PHPMyAdmin (presumably because it's using the
root user?). I've recreated the user I ordinarily use to get to my
databases and have given it global privelages, but still can't get it
to work.
Does anyone have any suggestions as to how I might fix this?
Much warmth,
Murray http://www.planetthoughtful.org
Building a thoughtful planet,
one snide comment at a time... 3 1658
M Wells wrote: I've recreated the user I ordinarily use to get to my databases and have given it global privelages, but still can't get it to work.
Can you connect to the database in the mysql CLI, using this login?
If not, did you use the FLUSH PRIVILEGES command after creating the user
and granting privileges?
These are pretty basic questions, I'm just trying to rule out the easy
stuff... I frequently have to slap my forehead after making such a mistake!
Regards,
Bill K.
On Sun, 07 Nov 2004 11:34:42 -0800, Bill Karwin <bi**@karwin.co m>
wrote: M Wells wrote: I've recreated the user I ordinarily use to get to my databases and have given it global privelages, but still can't get it to work.
Can you connect to the database in the mysql CLI, using this login?
If not, did you use the FLUSH PRIVILEGES command after creating the user and granting privileges?
These are pretty basic questions, I'm just trying to rule out the easy stuff... I frequently have to slap my forehead after making such a mistake!
Hi Bill,
Yes, I can connect using the mysql CLI with the username and password,
and can 'USE' the database in question and select records from it.
I haven't tried FLUSH PRIVELEGES, but I can give that a try as well.
Any other suggestions / thoughts?
Thanks for your help...
Much warmth,
Murray http://www.planetthoughtful.org
Building a thoughtful planet,
one snide comment at a time...
On Sun, 07 Nov 2004 20:01:06 GMT, M Wells <pl************ **@gmail.com>
wrote: On Sun, 07 Nov 2004 11:34:42 -0800, Bill Karwin <bi**@karwin.co m> wrote:
M Wells wrote: I've recreated the user I ordinarily use to get to my databases and have given it global privelages, but still can't get it to work.
Can you connect to the database in the mysql CLI, using this login?
If not, did you use the FLUSH PRIVILEGES command after creating the user and granting privileges?
These are pretty basic questions, I'm just trying to rule out the easy stuff... I frequently have to slap my forehead after making such a mistake!
Hi Bill,
Yes, I can connect using the mysql CLI with the username and password, and can 'USE' the database in question and select records from it.
I haven't tried FLUSH PRIVELEGES, but I can give that a try as well.
Any other suggestions / thoughts?
Okay, after some Googling it turns out that I needed to change my
MySQL user passwords using the OLD_PASSWORD function.
I'm wondering why this was necessary for PHP version 4.3.6?
Still, it appears to now be back up and working.
Much warmth,
Murray http://www.planetthoughtful.org
Building a thoughtful planet,
one snide comment at a time... This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Stefan Hinz |
last post by:
Degan,
jumping in to try and solve some problems that look pretty obvious to
me ...
> #options for default service (mysqld2)
> (mysqld2)
It should be , not (mysqld2).
|
by: Bill Hernandez |
last post by:
Hi,
I've been writing software on the mac since 1987, but am brand new at
unix/php/mysql, and that's where I'm headed so I'm reading everything I can
get my hands on, but like anything else there's going to be a learning
curve, that having been said...
I followed the install instructions at http://entropy.ch , and was able to
get mySql & php installed on my G4 -> (OSX 10.2.6) last night. I downloaded
Navicat and setup a password for...
|
by: BDR |
last post by:
Questions for anyone with experience on this topic...
Sit: We're running a standalone server with applications/db's written
around 3.23.41. Linux R/H 7.2 with updates. This is an Apache
production server (currently in operation w/12 co domains) and we're
about to launch new apps using Mysql now that the s/w is complete.
Before we do this, there is a lingering q of whether or not to take
advantage of a 4.x upgrade at this time, before...
|
by: Pugi! |
last post by:
On a freshly installed Fedora C3 (incl. webserver apache php mysql) i get
the following problem when connecting to mysql through a browser
(phpMyAdmin):
:
#2002 Can't connect to local MySQL server through socket
/var/lib/mysql/mysql.sock
On the website of MySQL this error is mentioned but I found no solution.
In /var/log/messages the following log occurs :
|
by: jiing |
last post by:
Now let me describe what I have done and my purpose:
Originally, I want to user ports to install phpBB
But I found that phpBB doesn't support mysql 5.x (but the ports
installed mySQL 5.0.0 alpha)
so I deinstall mysql5-server and mysql5-client
And then I install mysql41-server and mysql41-client on FreeBSD 5.3 by
ports
but now , mysql is not workable
| |
by: wideangle |
last post by:
Hello there!
I know it's stupid, but when creating a table in a mysql (win32)
database, it won't let me create this "mytable". Here goes my
ER_PARSE_ERROR.
mysql> CREATE TABLE `mytable` (
-> `mytable_id` int(25) NOT NULL auto_increment,
-> `mytable_title` varchar(100) NOT NULL default '',
-> `mytable_dts` varchar(25) NOT NULL default '',
|
by: wzhao6898 |
last post by:
Hi there,
I'm trying to figure out if it's going painless to upgrade our oooold
mysql 3.23 to the latest MySQL 4 or 5.
Any suggestions?
Thanks in advance!
David
|
by: Carlo Tambuatco |
last post by:
I have set up MySQL on my home computer, and I am writing a PHP enabled web
site to run queries on this database.
I have created a database called 'weather' on mysql that I want to access
via my website.
I have also created a user with a password (this isn't the real one, but
I'll use this to illustrate my point)
User: carlotam
Password: blah
|
by: xiuchuanli |
last post by:
I install Fedora 4 with web server, after that I installed mysql
5.0.15. Now I can connect to mysql from command line and
mysql-administrator and mysql-query-browser. But when I try to test to
connect from php code, it told me that "can not connect to local mysql
through /tmp/mysql.sock. /tmp/mysql.sock is my sock file to connect and
permission is set good. when I add phpinfo() to my php code, it show me
that mysql lib php uses is 4.1.X,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
| |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |