MySql issues I can't resolve

[reggler]

Hi There,

I would like to setup phpmyadmin on my system with apache and all (LAMP), you kow, doesn't seem like a huge issue you would think... heh, think again! However, so I got apache going fine ... so the L, A & P part of LAMP works and but the M...mysql was installed already and is being used by Akonadi. Now weird is, there's no user root and my default user isn't root, so who has the root privileges on my server? How do I best get this up and running...

reg@reg-desktop:~$ ps ax |grep mysql
 1403 ?    Ssl  0:47 /usr/sbin/mysqld
 1727 pts/8  S+   0:00 grep mysql
 2722 ?    Sl  37:34 /usr/sbin/mysqld --defaults-file=/home/reg/.local/share/akonadi//mysql.conf --datadir=/home/reg/.local/share/akonadi/db_data/ --socket=/home/reg/.local/share/akonadi/socket-reg-desktop/mysql.socket

Thanks for some assistance!
Ron

[reggler]

[RESOLVED]Re: MySql issues I can't resolve (Akonadi & Co)

Turned out I messed up, I let me log in with "mysql -u root -p", it would ask me for the password I would type the password and it worked like a charm! Only need to configure phpmyadmin now and i'm good to go!

[reggler]

Re: MySql issues I can't resolve (Akonadi & Co)

Uh, Reopening this thread as I cannot get connected to my mysql server with apache(php). Seems like I cannot get phpmyadmin nor joomla to connect to my db succesfully but I can login on the shell just fine.
What couldbe messed up here?

Any hints & suggestions are appreciated!

Thanks,
Ron

[SteveRiley]

Re: MySql issues I can't resolve

Perhaps the ApacheMySQLPHP page at Ubuntu would be helpful?

[reggler]

Re: MySql issues I can't resolve

Perhaps the http://ApacheMySQLPHP page at Ubuntu would be helpful?

Thanks, I've been there and checked things... but nothing...

The mysql section of my phpinfo() looks like this:

MySQL Support	enabled
Active Persistent Links	0
Active Links	0
Client API version	mysqlnd 5.0.8-dev - 20102224 - $Revision: 310735 $

Directive	Local Value	Master Value
mysql.allow_local_infile	On	On
mysql.allow_persistent	On	On
mysql.connect_timeout	60	60
mysql.default_host	no value	no value
mysql.default_password	no value	no value
mysql.default_port	no value	no value
mysql.default_socket	/opt/lampp/var/mysql/mysql.sock	/opt/lampp/var/mysql/mysql.sock
mysql.default_user	no value	no value
mysql.max_links	Unlimited	Unlimited
mysql.max_persistent	Unlimited	Unlimited
mysql.trace_mode	Off	Off

[SteveRiley]

Re: MySql issues I can't resolve

Hmm...perhaps a broader Google search, then. Wish I could assist more, but alas, databases aren't my forte.

[barbolani]

Steve, the MySQL that comes with Akonadi is specially configured for that and I believe not intended to be used as a general purpose DBMS, but only for Akonadi. I'd recommend you to install the MySQL packages from the standard repos. From there you can follow any standard Ubuntu guide and will work as expected.