How do I do that? Is it possible? If it's not possible in phpmyadmin then can you tell me some alternative to achieve the same thing (putting a password to the mysql database that is being exported for backup)? ...
is it possible to automatically export mysql database in phpmyadmin ...
Hi all, I didn't write any trigger for my works. Now i want to know how to write trigger . And where it write . Is it possible to write trigger as sql query in phpmyadmin .. Please help me to write a simple trigger... I tried like below Create Trigger sales_bi_trg BEFORE INSERT ON sales FOR EACH ROW BEGIN DECLARE num_row INTEGER ; D...
I am writing a code that access a MySql database. The database is on a server that we access through our web-browser Let's say, URL: http://cbm.goo.com/phpMyAdmin Username: username Password: password The above username and password are used to access the MySql database through a web-browser. Q1. What would be database ...
Up until now I can't figure out why is phpmyadmin inaccessible when I put a password on the root user. But I've seen someone accessing phpmyadmin and inputting a username and password. How do I do that, so that I can access phpmyadmin even when I put a password to the root user. Because maybe by default the login form is inaccessible. D...
please help, Im always having trouble having to go through all this stuff. When all I need is for phpmyadmin to have a login form so that I could input the password and username. I don't need all the stuff included in this documentation. Is there a tutorial for beginners on how to have a login form in phpmyadmin. Documentations like this...
I get this error everytime I try to access phpmyadmin. http://i49.tinypic.com/ot1478.jpg I cant access it because I've put a password on the root user. How do I get to have a login form in phpmyadmin so that I could at least try to authenticate that I'm the root user. Because in its current state, it wouldnt even bother to authenticate...
Do I have to download any files in order to have a login form in php. Ive asked this a million times but Im not sure if you guys gets the question or not. All I want is a login form. In phpmyadmin. Wherein you will input your username and password. DO i have to create any php login form or is it already included when you install wampserv...
Need some guidance figuring out what went wrong. I've been using mysql, phpmyadmin for just under a year on my home computer while I develop a webapp. 3 days ago I updated my windows vista with all the "wonderful" microsoft updates, security patches, etc...and now it's broke. I tried uninstalling all the upgrades, but there are 4 of th...
I want to know this because I want that localhost or phpmyadmin will not be accessible on the web browser(portable or installed). Is there any setting in phpmyadmin which identifies where the web browser is? Would the trick of uninstalling the web browser set as default browser for viewing localhost work? I just want it to be inaccessibl...
Hello, I am using a platform (perfectforms) that requires me to use stored procedures for most of my queries, and having never used stored procedures, I can't figure out what I'm doing wrong. The following statement executes without error: DELIMITER // DROP PROCEDURE IF EXISTS test_db.test_proc// CREATE PROCEDURE test_db.test_proc() S...
hello once i try to connect to mysql on phpmyadmin in ubuntu i got this error 2002 - The server is not responding (or the local MySQL server's socket is not correctly configured) but with mysql query browser i connect with out any error and it works why phpmyadmin does not connect? ...
For example I have a table. With a field Idnumber. And the field has 10 data(ex: 1234, 1235, 1236, etc) And I have another table, subjects. Is it possible to import the data that is in the table student(field idnumber) and put it on the table subjects(field idnumber)? So that I won't have to copy and paste the data that is in the source ...
My app no longer connects to its DB and phpmyadmin says #1129 - Host 'xxx.xx.xx.xx' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts' mysql_error() prints out the same message. Could this be because of too many connections? What causes this? ...
Hello, I would like to install Jobberbase in my website. I have a hosting plan with JustHost. Any easy step by step guide to install this job board would be greatly appreciated? Many Thanks! ...
I have inherited a website that needs the password changed that accesses the database. I can see that there are two tables within the database but neither of them have username or password info. The previous web guy moved out of the country and can't be reached. I am not up-to-speed enough to figure this out. I have gone through all ...
Hello - it appears that somehow in the past, wordpress saved multiple redundant post-meta for post revisions which are no longer in the database. As a result, I have a ton of post-meta that does nothing and is tied to posts that no longer exist. Does anyone know how to remove this data in myPHPAdmin with a SQL querey? Thanks in advanc...
Here is my problem: The Key "idx_SR_u_Identity_FingerPrintProfile" is meant to constrain the fields "c_r_Fingerprint" and "c_r_Profile" to be unique. It seems that I have done something wrong because all 4 entries in the table have identical values for those two fields. It is okay if two records have the same Fingerprint OR the same Pr...
I have some users setup in a MySQL table with different variables. I am trying to figure out what would be the best way to do this. Basically I want to award all of my registered and active users with bids which are stored in another table. So for the Table "users" I have ran this query: SELECT * FROM `users` WHERE `active` = 1 ...
I have a MySQL user added to a database that I would like to prevent from viewing certain tables. I can limit their privileges through MySQL by preventing them from running statements like DROP or ALTER. But is it possible to prevent them from viewing certain tables in phpMyAdmin? If there isn't a MySQL privilege that controls this (I...