I recently created a password for my MySQL Server for security purposes for my website. I forgot my password thus I cannot access my server. I did not create a back up and I cannot dare to delete the DB server.

How do I access the MySQL database users table and reset my root password?

Thank you in advance.

I am using Netbeans for java work. I created one application & now I want to insert some data in this application. For this purpose I need SQL server connection but when I try to connect it with SQL, I receive the below error.

Tell me its detail:

Database Error

            A COM exception was thrown inside “CwuADODatabbaseMgr::GetErrors”

            Error: -2147467261

            Error Message: Invalid pointer

Hi all,

Please provide me a solution to insert the text which has apostrophe. Example : aaab's.

Messages:

Msg 102, Level 15, State 1, Line 1

Incorrect syntax near 'GH'.

Msg 105, Level 15, State 1, Line 1

Unclosed quotation mark after the character string ')

'.

Thanks in advance.

Grahamamie

I have installed XAMP server to my computer, but at the end of installation, it shows a message that, "ports 80 or 443 (SSL) already in use! installation apache 2.0 service failed!". But when I run the XAMP server, firstly Apache does not run, but if I start Apache, then it runs as usual. When I created a database and installed CMS system, it shows an error.

Hi,

Hi,

What is normalization? and what is de-normalization?

Explain different levels of normalization.

Can anyone help me understand this?

Regards

Can we get SQL table content results, along with headers?  Say I have a table that has 10 fields of data.

Select * from Patients

I want to copy the content of the results with the headers. Is this possible, I am using SQL 2005?

Hi Experts,

Need your help. I am using Oracle 10g database. I have developed a script in which I have used UTL_FILE api to read data from a file. While running the script I am getting error like identifier 'UTL_FILE' must be declared. I am sure the directory "fileout"  and file "MYFILE"  is present in the database.  Please let me know the reason for this error and how to resolve this issue. Here I've attached the screen shot of the error. 

Error:

Hi,

we are going to develop a new web based application for our small scale manufacturing company. Can someone explain to us, how to choose a right Database and what are the basic things that are to be verified before contacting a vendor?

Many thanks in advance for the help.

Hi There!

I want to create Wordpress chatting website for my friends. But I cannot install my Wordpress app in the FTP client.  I use FTP client software for file uploading to root directory every time I try to upload my Wordpress software. But I cannot upload it by ‘Filezilla FTP client’.

It gives me a message: File cannot be uploaded. Try again later.

Please help me.

Error: