i was under the same impression, but i set up a wiki on my server and i
noticed that the mysql_connect command the wiki uses doesn't
authenticate with my mysql server password.
when i initally set up the wiki, it asked me to create a pw for the
wiki DB. this pw was not my mysql user pw.
how is it still able to query the wiki db (without my mysql user pw)
then?
i also wrote my own php script and provided the wiki DB pw to the
mysql_connect command. the connection surprisingly also worked.
// case B:
$link = mysql_connect('localhost', 'mysql_user', 'wikiDB_password');
mssql_select_db('[anotherDB]', $link); // fails as expected - didnt
create pw for this DB
i shutdown my wiki and restarted it before trying the above too. how is
this possible? case B makes me think you can set DB specific pw...?
thanks markus and mike =) i looked more carefully into the link markus
pasted, and there is mention of "user permissions is which databases
can be accessed" with the "GRANTS" command.
kani
I am developing a small website using ASP scripts to format data retrieved
from an Access database. It will run on a Windows 2003 server supporting
FrontPage extensions 2002 hosted by the company...
I used Enterprise Manager to change the data type of one table column
from one thing to another. When I attempted to save the change, I was
warned that "one or more existing columns have...
Can I set the Format property in a date/time field in code?
Can I set the Input Mask in a date/time field in code?
Can I set the Format of a Yes/No field to Checkbox in code?
I am working on...
Hello,
I originally installed postgresql as root user and now I am setting up a
development environment with cvs and a java ide and tomcat. I have
everything with the exception of postgresql...
I was wondering if setting object vars to Nothing near
the end of a sub procedure was beneficial at all - since
they (the OV's) are about to go out-a-scope anyway?
For example,
Sub MySub()...
Hi,
I'm using PHP 4.4.4 on Apache 2 on Fedora Core 5. PHP was installed
using Apache's apxs and the php library was installed to
/usr/local/php. However, when I set my "error_reporting"...
Hi All,
I am using DB2 UDB enterprise server unlimited edition on linux
platform. We have completed entire database as well as front end (web
application in JSP using JBOSS) development. Its all...
In an application I'm loading a RTF value from a database into a richtextbox.
After setting the RTF property of the richtextbox control I notice that this value is different than the database value...
Hello Guru's
I am new to db2 and need some help with setting up a new database.
So far I have created the database. "DB2 create database" And was sent the .sql file would this be the DDL? At...
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
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...