Display :
Category: MySQL Server

Hello! Please help me with the following:

I have a table dle_post id autor date short_story full_story xfields title descr

How can I get the piece of code from full_story and change it for mine? For example I need to change <img border=”0” to <img

Also for example I have news under ID 1 to 1000 and I need to set date in the same field like that

one value for 1 to 100, the other one for 101 to 200 and etc. How can I do that?

Category: MySQL Server

Why can’t I connect to remote MySQL from virtual private server? I use ocentOS 4 virtual server that was set up with plesk. I have been trying to connect to remote MySQL from VPS but the connection was not established. I allow remote MySQL from host and also allow outgoing transmission protocol (TCP) port in cof.conf. What other methods can I use in troubleshooting?

Category: MySQL Server
Hi there, I'm new to WordPress and just forgot my admin password... 
 
Is it possible to execute some MySQL statement in order to reset the password?
 
I do have access to phpMyAdmin.
 
Thank you for your help.
Category: MySQL Server

Recently, I installed MYSQL server on my machine which runs on Windows operating system. I started having problems with MYSQL so I decided to uninstall all programs relating to MYSQL. So far, I have been able to uninstall everything except one stubborn program called MYSQL Connector Net 6.8.3. For some unknown reason this particular program has refused to uninstall when I use the normal procedure for uninstalling programs in Windows OS. What is the most likely cause of this issue? What alternative way can I use to uninstall this program?

Category: MySQL Server

What is System R? What is its connection to the SQL programming language? What are its two major subsystems? How is System R different from the relational structure in terms of its data structure? Are domains supported in System R ? How does System R help in achieving data independence?

Category: MySQL Server



I am thinking of designing a very large database that can handle close to a million people. What best policies do I need to consider when designing such a system? Which potential bottlenecks does such a large systems present to designers and coders? How do I resolve the common bottlenecks associated with this kind of project?

Category: MySQL Server

I am having difficulty gaining access to Mysql database tables. The database is managed with EasyPHPDevServer which appears to be working alright, but unfortunately, I cannot connect to the database using normal log in procedure. How can I identify the cause of this incident? Which areas of the database system should I start the forensic investigations in order to identify the root cause?

Category: MySQL Server

What other alternative database server can I use to manage mysql databases? I am currently using EasyPHPDevServer. It has not worked properly for many months now, so I will like to know what other suitable alternatives to go for. Which alternative is more efficient and robust? Can I download it for free? Where can I go to download this alternative?

Category: MySQL Server

I am having problem connecting to mysql database on my laptop. The database system has a front-end written in PHP and HTML. I am able to log in using my credentials which are stored in the database but when it comes to actually connecting, I get the message, ‘unable to connect to the database’. How is that I can log in with my credentials stored in the database table, but I still get an error message, ‘unable to connect to database’? What could be the problem? How do you resolve this issue? I have already uninstalled and reinstalled the EasyPHPDevServer several times, but the problem persists.

Category: MySQL Server

How do you package a database system with a PHP and HTML front-end having mysql database backend? What tools are available to help with packaging a database system as a self-extracting file? Would I have to write codes to process the database file into a single self-extracting executable file or there are some resources to deploy for the task?