• Changing privileges for already created MySQL user

    For MySQL, how can I change the privileges for already created users (not new users)? My company is running an audit on our database and we noticed that some people have more access than they should. Thanks!

    ITKE380,425 pointsBadges:
  • How can I setup an Ubuntu server for sending emails in PHP

    Can someone help me with setting up an Ubuntu server? I have to send emails in PHP using the mail() function. I already have Apache, PHP and MySQL in my server. I appreciate the help.

    ITKE380,425 pointsBadges:
  • Bind more than one IP address in MySQL

    In MySQL, would there happen to be a way to bind two or more IP addresses? I need to use more than one IP address and the 'bind-address' in my.cnf won't work. Thanks!

    ITKE380,425 pointsBadges:
  • Copy MySQL usernames and passwords from one server to another

    Over the past week, I've been setting up a new MySQL server for my work and I have to give it the same set of usernames and passwords from the previous server. Can I do a dump from the previous server and load it to my new server? Or is there another way?

    ITKE380,425 pointsBadges:
  • How to change column name in MySQL

    I need to change column name in MySQL. What should be the command for writing it?

    sachnikh15 pointsBadges:
  • Run PHP script in AS/400 batch

    We have an application on our AS/400 where we are passing changes to data down to a MYSQL DB on a server. Using a purchased product we have issues when passing large amounts of data, Were get JAVA heap dumps. So I am replacing this with a PHP process. The RPG code writes SQL statements to a file...

    CharlieBrowne42,980 pointsBadges:
  • ODBC AS/400 connect to MySQL

    I am trying to figure out how to get data from the AS/400 into MySQL.

    Sunnyday25 pointsBadges:
  • MySQL stored procedure debugger tool

    Hi, I am looking for a MySQL stored procedure debugger tool for Ubuntu (Unix). Can someone help?

    Perfsid5 pointsBadges:
  • Should I use mysql_* functions?

    I'm pretty new to MySQL and my friend told me not to use mysql_* functions. Can anyone tell me why this is the case? Security concerns?

    ITKE380,425 pointsBadges:
  • Free online practice exercises on SQL/Oracle

    I would like to know is there any website which offers free practice exercises on SQL/Oracle queries? Preferably advanced level queries. Thanks, Kruti

    Kpatel0 pointsBadges:
  • Hardware sizing for the infrastructure

    Hi, I would like to do the Hardware sizing for below applications on Linux based OS both in Physical and Virtual environment, can someone provide details on how many servers, type of servers, storage, network and other if related to sizing required to setup centralized for 2000 to 50000 concurrent...

    12480355 pointsBadges:
  • Rename a MySQL database

    Is there a way to rename a MySQL database? I know that I can just dump the database / reimport it but I can't do that with mine. It's a huge database. Also, it needs to work with InnoDB. Thanks!

    ITKE380,425 pointsBadges:
  • PCI compliance issues on MySQL database

    We use Stripe to process credit card information / store client's payments in our MySQL database. We only store the ID of transaction and the client ID. And Stripe controls the PCI compliance issues. We also isolate payments to a single box that hosts the database and payment site. Now, here's our...

    ITKE380,425 pointsBadges:
  • Does temporary storage of credit card info meet PCI DSS requirements?

    For our department, we need to make sure that our temporary storage of our user's credit card information meets PCI DSS requirements. We have to make sure that deletion is compliant DoD's security standards. We thought about using MySQL but we're not sure about the reliability. What should we do?

    ITKE380,425 pointsBadges:
  • Storing billing data in a MySQL database: A PCI compliance violation?

    For the past several months, I've been developing a shopping cart and I need to store Name, Billing, Address and Zip Code into a MySQL database. I'm doing this because a returning customer wouldn't have to re-enter billing information. Also, I'm not storing any credit data. Just to ask, am I in...

    ITKE380,425 pointsBadges:
  • PHP installation error: Missing MySQL extension

    Hi experts, I keep getting this error when I'm trying to install a PHP: "Your PHP installation appears to be missing the MySQL extension which is required by WordPress." I've been using my NAS with a telnet connection. Here's what I have: ;If you wish to have an extension loaded automatically, use...

    ITKE380,425 pointsBadges:
  • Is MySQL robust enough for very high traffic websites?

    Just so you have an idea of what I'm asking or looking for as far as database needs , I'm working on a classified ads website gaining a lot of traffic. The database behind it is MySQL. However, my concern is if MYSQL is fit to handle high traffic websites. For example, would a website with 12...

    itguyla5 pointsBadges:
  • Handle MySQL backups with Git

    For our MySQL backup, we came up with a pretty good idea but we're not entirely sure. To backup it up, we thought of putting the dump file into a Git repository, and the commit on each dump so we have the most recent copy / we can roll back to a previous backup. But we're not sure of the flaws...

    ITKE380,425 pointsBadges:
  • How to do MySQL backups on a budget

    Our MySQL backup strategy is to replicate our database to a second server and then run mysqldump on that server to get rid of any downtime from table locking. It's working great but the cost is huge (Over $150 per month on that second server). Anyone know of another way to do MySQL backups cheaper?...

    ITKE380,425 pointsBadges:
  • Performance issue with MySQL database backup

    My friend and I have been trying to create a regular backup for a production database (large one, in fact). The database has both InnoDB and MyISAM tables. We have been using mysqldump but it keeps taking longer and longer each time. Sometimes, the server is even unresponsive when the dump is...

    ITKE380,425 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following