Tag Info

New answers tagged

0

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';


0

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 ...


1

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 ...


1

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