New answers tagged phpmyadmin
mysql -u akht -p(akht is my database name) -u is for "user"; -p (without a space after it) is for "password"; a lone word (no -x before it) is the database name. GRANT ALL PRIVILEGES ON dbname.* TO 'fred'@'localhost' IDENTIFIED BY 'password';
Have you tried logging in to PHPMyAdmin as root? You should have been asked to give a root password when you installed MySQL. Create a user ("fred") and then give fred privileges to access/manipulate that db - GRANT ALL ON My_database TO fred (or similar (from memory... check the docco). [EDIT] My thanks to my learned friend @RickJames for providing the ...
You can create a new table like the old one and insert the values in a different order, for example: CREATE TABLE new_table like old_table; INSERT INTO new_table (date, name) SELECT date, name FROM old_table ORDER BY date ASC, id DESC Change the ORDER BY to whatever suits to you- I have ordered by date so it doesn't trust that the original data was ...
The database server that you are accessing using phpmyadmin and the mysql monitor (command line client) are different. If you look at the versions, phpmyadmin is accessing a 5.5.1-m2-community version, while you are accessing 5.6.17-community on the command line. Either you are accessing a remote server or you have two separate installations of mysql on the ...
Top 50 recent answers are included