I want to configure phpMyAdmin to be able to accept one of several different user account logins. Each user would be allocated a specific database and only have access to that. The default configuration with phpMyAdmin is one super user, e.g. root which has access to every database on the server. I need to be able to give people access...
Hi there, I raised a question about this a while ago but I'm still having an issue. I have a mysql5 database with a sales table that contains a timestamp to represent a sale. If a field in the sales table in amended or altered the timestamp updates to the current time (the time of the change). To prevent this I have unselected the on_up...
How it is possible to update localhost MySql database with server mysql database at particular interval. Web application is made in PHP and database should be in MySql. Suppose I have a Database at Hosting site Now i want to update my database at regular interval with Local Host Database at my Local Computer.Please suggest me ?? ...
Hi All, I have a website in which the content on the index page is controlled by a PHPMyAdmin database. I want a a flash "movie" at the top, that can take the data from the site, and slide-show it until a user clicks on a specific link, in which the movie will direct itself to the clicked event. The page is for a booking/promotion conce...
I don't see the "relations view" that used to exist. Any suggestions? I'd rather not have to drop all of my tables in order to do this. ...
I'm running this sample code I found while googling: SELECT MD5(RAND()) But, to my surprise, MD5 is returning plain digits, instead of hexadecimal digits. Using CONV(MD5(RAND()), 10, 16) seems to solve my problem, but the MySQL documentation states that the MD5 function should return a string already in hexadecimal. Am I doing someth...
Possible Duplicate: How to secure phpMyAdmin I use phpmyadmin to preview the database of my website. However, everyone can access the login page of my phpmyadmin by simply typing example.com/phpmyadmin I am not an expert in network security but I assume this isn't very secure. How can I restrict the access to the login page(...
Hi there! I have installed MySQL server enterprise 5.1 on my local machine and now I want to install phpMyAdmin.. but it does not work. I have unrared phpMyAdmin to my server root directory and browsed to "localhost/phpMyAdmin/setup/index.php", started a new server and the only setting I changed was filling in my MySQL password in the ...
Which scripts/solutions do use for import and export large mysql databases? Phpmyadmin gives an error for these operations, if there is a big amount of data. ...
I'm a complete mySQL & PHP noob, and in my table, whenever there is an apostrophe, it gets replaced by ’. I've searched and found that it could be because my table is not UTF-8, but I changed all the collation settings in phpMyAdmin to utf8_unicode_ci, and I still get the ’. To be clear, I am sending the data to a PHP script from a...
Hello, I'm trying to create the following table using phpmyadmin sql console: CREATE TABLE dates ( id int NOT NULL, id_date datetime NOT NULL DEFAULT CURDATE(), PRIMARY KEY (id) ) However I get the following error: It shows "CURDATE()" in red, so I guess that's the problem. Could anyone help me out here ? ...
I have CPanel access to a website with a MySQL database. My question is, I want to give another user access to the database but only through PhpMyAdmin and not the CPanel login. Is there a way? PS: (I am happy for this person to view, edit and download the data in Excel format) Cheers ...
I have added some constraints to some MySQL table fields. This seems to change phpMyAdmin a little bit, including constrained fields being presented as drop down boxes in edit or insert mode: This looks a bit weird to me, as if phpMyAdmin wants to add titles but doesn't have the correct information. Am I correct in this assumption? A...
hello, tryin to install phpMyAdmin on my Fedora server, but if i open it in browser, i get next error: 2002 Cannot log in to the MySQL server file config.inc.php have next content: <?php /* Servers configuration */ $i = 0; /* Server: localhost [1] */ $i++; $cfg['Servers'][$i]['verbose'] = ''; $cfg['Servers'][$i]['host'] = 'localhos...
I've been provided a csv file which contains an export of a client's database table. Two of the columns are dates, and in the file they're formatted as mm/dd/yyyy. ID | ActivateDate ----------------- 1 | 05/22/2010 2 | 10/01/2010 Our mySQL database that I need to import them into has those columns defined as datetime, with a defaul...
Hello I have created a sequence of test cases and then test suites from these test cases. Now if move these test suite to some other folder where the test cases are not present then i'm not able to run the test cases from the new location .Test suites are not working. What is a solution for this ??????? ...
So I'm impoting a 80000+ lines .cvs files to a MySQL database, using Import CVS via LOAD DATA in phpMyAdmin, and it seems to work fine, there are no error messages. Problem is, ater the import, all lines in the table, starting with line 24002 have the same number in one of my database fields, and this number doesn't even exist in the .c...
I am trying to join 4 tables but having issues. my code is listed below. The error I recieve is #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ON advancedcatalog_font_type.id = advancedcatalog_dimensions.font_type_id) LEFT ' at line 6 adva...
HI, I am trying the below code . $domain = $_GET['url']; $sql = 'SELECT * FROM `domains` WHERE `domain` REGEXP CONVERT(_utf8 \'$url\' USING latin1) COLLATE latin1_swedish_ci'; $result = mysql_query($sql); while($row = mysql_fetch_array($result, MYSQL_NUM)) { echo "id :{$row[0]} <br>"; } will get the domain from user using $_...
i have two tables one is table 'a' and second is table 'b'. in table 'a' there are five fields and a_id is assigned as primary key and in second table 'b' there are two fields and b_id is assigned as primary key.there is one common field name in both table as cust_name.my problem is when i insert value in table 'a' then table 'b' should ...