Installing phpMyAdmin in Ubuntu 10.04 and following
The MySQL database is administered by text commands on the command line. Doing so is quite hard, and alternatively using applications that abstract the complexity of use. Some of these applications are programs installed on your machine, available in the C enter Ubuntu Software. On the other hand this PhpMyAdmin is a web application in order to administer the database server and make it through a browser.
With PhpMyAdmin can among other things create, view, edit, delete users, tables or databases from the server using only your web browser. All this makes this necessary tool in the administration of a server LAMP .
PhpMyAdmin is available in the official repositories of our Ubuntu. Rarely need to administer MySQL to use the latest version, so that available in the repositories meet our expectations.
Ubuntu 10.4 install our Lucid Lynx or Maverick Meerkat is simple. Open a terminal from Applications -> Accessories -> Terminal or by pressing CTRL + ALT + simultaneously and copy T to run the following commands:
sudo apt-get update
sudo apt-get install phpmyadmin
After that start to download and install packages. In the end it will open a dialog that will ask about data needed to configure itself. We asked if we want to configure with Apache2 or Lighttpd. If the server is LAMP, Apache2 and accept only mark. After asking us if we want the installer to create a database for use phpmyadmin, to which we respond with a yes. Then we asked the root user password needed to to set the previous step. Then another password to phpmyadmin and confirmation. Finally phpmyadmin is installed.
To use phpmyadmin just go to http:// domainname / phpmyadmin where the proper domainname adapt to our situation. If our server is on the local machine can use http://localhost/phpmyadmin or http://127.0.0.1/phpmyadmin
January 11th, 2011 at 18:02
Information Bitacoras.com ...
Rate in Bitacoras.com: The MySQL database is administered by text commands on the command line. Doing so is quite hard, and alternatively using applications that abstract the complexity of use. Some of these ......
January 31st, 2011 at 11:07
Thank you very much for your guidance, in my case when I access phpmyadmin as root displays all right but I get this sign on the option to create database:
Create new database:
X without privileges
either locally let me access the mysql database to change the permissions, I've tried several guides to resolve the problem but can not find one that works for Ubuntu 4.10
February 2nd, 2011 at 17:27
I do not understand what 'local'. If you are using phpmyadmin your carrier will limit the use of databases that have contracted with them.
February 3rd, 2011 at 22:52
Local I mean I'm on the server where you installed the mysql, when I try from another computer via phpmyadmin not allow me to access the sql server with privileges to create databases CHANGE ME AND GRANT USER PERMISSIONS
February 3rd, 2011 at 23:20
If the mysql server is implanted hosting provider limitations in terms of the service packages they sell. If you sell a database that's all you're going to have. You do not say if this or against it is a server that you have mounted your home (local) you will not have any limitations. Greetings.
February 5th, 2011 at 16:49
I do not think I explained well, I have a machine (mine, in my house) in which I have installed Ubuntu 10.04 and I have installed the mysql paqutes, phpmyadmn etc, after that it s set up and put my password to the server mysql databases and now auque between the user and password denieed Access tells me, now I want to do is get out of this situation either reinstalling mysql, (I have not created any database in importance) so I would not mind reinstalling, which I did but still with Access denied) and not know what else to do
February 5th, 2011 at 18:25
you put in the installation root password, you tested that?
root / password?
If you do not like this help you:
http://es.kioskea.net/faq/2012-reinicializar-la-contrasena-de-root-de-mysql
February 7th, 2011 at 11:00
Thank you very much, we have advanced but the problem persists, you get what I did, I gave the same password for all users ...
jml58z jml58z @ ubuntu: ~ $ sudo mysqld-skip-grant-tables-skip-networking &
[1] 2067
jml58z jml58z @ ubuntu: ~ $ mysql-u root mysql
Reading table information for completion of table and column names
You can turn off this feature to get a Quicker startup with-A
Welcome to the MySQL monitor. End With Commands; or \ g.
Your MySQL connection id is 2
Server version: 1.5.41-3ubuntu12.9 (Ubuntu)
Type 'help;' or '\ h' for help. Type '\ c' to clear the current input statement.
mysql> UPDATE user SET password = PASSWORD ('micontrasenaNueva');
Query OK, 6 rows affected (0.00 sec)
Rows matched: 6 Changed: 6 Warnings: 0
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)
mysql> \ q
Bye
jml58z jml58z @ ubuntu: ~ $ sudo / etc / init.d / mysql restart
[Sudo] password for jml58z:
Rather than Invoking init scripts through / etc / init.d, use the service (8)
utility, eg service mysql restart
Since the script you are Attempting to invoke Has Been converted to an
Upstart job, you may use the restart Also (8) utility, eg mysql restart
mysql start / running, process 2383
jml58z jml58z @ ubuntu: ~ $ mysql-user 'root' @ 'localhost'-p
Enter password:
Welcome to the MySQL monitor. End With Commands; or \ g.
Your MySQL connection id is 6
Server version: 1.5.41-3ubuntu12.9 (Ubuntu)
Type 'help;' or '\ h' for help. Type '\ c' to clear the current input statement.
mysql> select * from mysql.user;
ERROR 1142 (42000): SELECT command denied to user '@' localhost 'for table' user '
mysql>
February 7th, 2011 at 13:30
I think that although extremely rare among root @ localhost as the server replies
mysql> select * from mysql.user;
ERROR 1142 (42000): SELECT command denied to user '@' localhost 'for table' user '
February 7th, 2011 at 18:07
@ Jozelo: I do not understand you have position, but as root you can not have total control, something did not install / you set it. In cases like this I try to isolate the error, would begin to do the installation on a virtual machine. Luck.